Tried that Bob, thanks.
Got it sorted though by tweaking Joel's response.
Appreciate the effort :)
--



"Bob Phillips" wrote:

Just change LARGE to SMALL in the formula.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"JockW" wrote in message
...
Thanks Bob. Sort of worked in that it correctly identified the gender but
gave the reverse order so that the slowest male had the lowest number
rather
than the fastest male and so on.
Ideally, I'd just like to 'suck' out the men's info from sheet1 to sheet 6
and the women's to sheet 7 and have them ranked by time with no empty rows
that, for instance VLOOKUP would give. The results are ging on a web site
so
user ability to use filters or pivot tables will vary a lot. Which is why
I'm
after the simple solution!

ta


"Bob Phillips" wrote:

Assuming that the time is in E, this gives M/F rankings

=$A2&"_"&MATCH($E2,LARGE(IF($A$2:$A$20=$A2,$E$2:$E $20),ROW(INDIRECT("1:"&COUNTIF($A$2:$A$20,$A2)))), 0)

which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets),
do
not try to do this manually.
When editing the formula, it must again be array-entered.

Note that you cannot use a whole column in array formulae (prior to excel
2007), but must use an explicit range.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"JockW" wrote in message
...
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