| gender | name | birthdate |
|---|
| male | john | 10/9/70 |
| male | elvis | 5/3/80 |
| female | jenna | 7/6/99 |
| female | eleana | 4/2/85 |
| male | colt | 4/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
Message was edited by: hydrofal78
Dell Inspiron 15 , Windows 10, null