View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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