I want to only return the true values, in consecutive cells, from an IF
statement. Is this possible? Currently using an IF statement and I can't do
this.

E.G
A B C
John Male Mary
Mary Female Jane
Paul Male
Simon Male
Jane Female

In the above example I just want to return the names of all females.
therefore column C is my desired result. Any help appreciated...