Hi, i'm trying to get two gender data, from two different sheets into a new sheet with ascending.
I don't know how to apply formula in it, here is my code for female
=INDEX('(female)'!B3:B300,SMALL(IF('(female)'!G3:G300=G2,ROW('(female)'!B3:B300)-2),ROW()-1))
In the list, B3 is the user's name i insert, and i wish to combine it with male and ascending into new sheet.
Is any other way to do it? i have tried used if statement, it's not working.
Thank you.
Bookmarks