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

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