hydrofal78

Q: Get only specific cells

gendernamebirthdate
malejohn

10/9/70

maleelvis5/3/80
femalejenna7/6/99
femaleeleana4/2/85
malecolt4/3/77

 

what i need is to put down here in these two columns the names that correspond to each gender

what formula do i use so every name added will automatically appear in the correct gender category in the second table ?

my brain is completely stuck, i know i have used this in the past but cannot figure it out

 

 

malefemale

 

Message was edited by: hydrofal78

Dell Inspiron 15 , Windows 10, null

Posted on Feb 3, 2016 9:29 AM