help! automatically separates the names based on gender.

[teyken24]

Greetings of Peace!

Can anyone help me with my problem, I want to automatically segregate the names in second sheet based on their gender.I am new to excel.

attached is my example.

[63falcondude]

In A5 =IFERROR(INDEX(Sheet1!$A$1:$A$38,SMALL(IF(Sheet1!$B$1:$B$38=A$4,ROW(Sheet1!$A$1:$A$38)-(ROW($A$1)-1)),ROWS($A$1:$A1))),"") Ctrl Shift Enter dragged down until you get blanks.

In D5 =IFERROR(INDEX(Sheet1!$A$1:$A$38,SMALL(IF(Sheet1!$B$1:$B$38=D$4,ROW(Sheet1!$A$1:$A$38)-(ROW($A$1)-1)),ROWS($A$1:$A1))),"") Ctrl Shift Enter dragged down until you get blanks.

Make sure that you delete the trailing space after MALE in A5.

[63falcondude]

Duplicate post deleted.

[sandy666]

or you can try with Pivot Table

[teyken24]

or you can try with Pivot Table

This saved me.. thank you so much

[sandy666]

You are welcome
If that takes care of your original question, please click Add Reputation then select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.