At least two males

[Matti Koski]

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

 

[Bob Phillips]

=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)