Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a list using a Lookup
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a list using a Lookup
=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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a list from another list ignoring duplicate entries from orig | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Lookup of Cells and transferring them to make a list | Excel Worksheet Functions | |||
V Lookup - How do you make the "Col_index_number" updated | Excel Discussion (Misc queries) | |||
List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions |