Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
At least two males
Hi Group
How can I pick up the families that have at least two males from the table below? Family code Sex At lest to males 2 male 2 female 2 female 3 female * 3 male * 3 male * 4 female 4 male 4 female 5 female 5 male 5 female 5 female 6 male * 6 female * 6 male * 6 male * Thank you, Matti |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
At least two males
=IF(SUMPRODUCT(--($A$1:$A$17=A1),--($B$1:$B$17="male"))1,"***","")
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Matti Koski" wrote in message ... Hi Group How can I pick up the families that have at least two males from the table below? Family code Sex At lest to males 2 male 2 female 2 female 3 female * 3 male * 3 male * 4 female 4 male 4 female 5 female 5 male 5 female 5 female 6 male * 6 female * 6 male * 6 male * Thank you, Matti |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Downloaded "Fitness Chart for Males" need it in metric? | Excel Discussion (Misc queries) | |||
Count number of instances in sheet e.g. how many males/females | Excel Worksheet Functions |