Ok, I have 7 sheets named: joe, kelly, meg, nate, dave, tom, sam

To keep it simple, in cell B2 on each sheet there is either "10" or
it's blank.

On an 8th sheet I'm trying to determine a formula to use that will
display the person or persons if their cell B2=10

So if meg's B2 has 10 and tom's B2 has 10, while everybody else B2 is
blank; the formula would produce meg & tom.

What formula would I use? Please help. Much appreciated for your help!

Thanks,


--
mrjeep
------------------------------------------------------------------------
mrjeep's Profile: http://www.excelforum.com/member.php...o&userid=34001
View this thread: http://www.excelforum.com/showthread...hreadid=537639