Race times are ranked in a worksheet by fastest times regardless of gender.
I wish to create seperate lists of athletes in another worksheet from that
information but listed by gender.
Column A has "male" or "female" and the rest of the row has other info such
as name, time, year and so on up to and including column G.
I am trying to avoid having lists with blank spaces, using filters and so
on. All I require is a simple list of females and another list of males from
the main data.

Any ideas?
--
tia