Make a list using a Lookup
Ok, but what about the mens, i see formulas for th ewomen (F)...and since
they are not all in the same colums, see i have some men and women put in
group for printout purposes....is that gonna work....
I can send it to you by email, if you want....
"Bob Phillips" wrote:
=IF(ISERROR(SMALL(IF($A$1:$A$20="F",ROW($A$1:$A$20 ),""),ROW($A1))),"",
INDEX(A$1:A$20,N(SMALL(IF($A$1:$A$20="F",ROW($A$1: $A$20),""),ROW($A1)))))
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.
Then just drag it across and down to fill in the rest.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Yan" wrote in message
...
Ok!
I need to do a list of people using either Female or Male
Ex: I need to find all women on my list and all man on the list
...including
anything beside their names..
m/f Equipe #1 Team Average: 513
Nom PJ T.Pts Moy.
F France Bigras 3 908 302
M Martin demers 3 634 211
I need to find all and to put them with complete stats.....
In 2 different colums..
Male
Females
Thx you!
|