excel, table formula 1

[faxof]

in the table below i have a count of how many people (out of 6) can and cant attend on a certain day.

on the next row i would like to display the name of the person who cannot make it (but only if the count is 5)

ie, if only one person cant make it then i'd like to display his name.
ie, the last row on monday shuold say andy and the last row on weds should say james.
chhers a lot

fax



mon tue wed
james y y n
phil y n y
pete y n y
john y n y
andy n y y
greg y y y

count: 5 2 5

 

[GlennUK]

Do an IF test to see if the count is 5, and if so do an INDEX/MATCH, like this:

=IF(B9=5,INDEX($A2:$A7,MATCH("n",B2:B7,0)),"")

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.