Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!
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 |