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
|