At least two males

M

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
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top