I tried the formula:

=IF(AND(Carlos!B3=8,Jim!B3),"Carlos & Jim","")

which works if both carlos and jim have 8, but what if just carlos or
just jim has 8?

I have 6 people that I need to include in a formula, where there could
be nobody w/ 8 to all 6 could have 8 or a variety of the 6. How would
I do this and what formula would I use? I've been searching around and
can't find a solution. Your help appreciated!!


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=537551