I searched the forums, but didn't see anything quite what I need.

I am using Excel to handle hourly assignments, and I want to be able to
note when more than one person has a meal. Each person has a row; each
hour has a column. Like so:

A B C D E F G
Name 10 11 12 13 14 15
Bob R M B
Harry R M R
Jenny B M

What I want is to be able in the D column to list that BOTH Bob AND
Jenny are at lunch--but I can't figure out how. The MATCH function only
gets the first entry; I have seen some array formulas that combine MATCH
and INDEX, but can't get my head around the ideas.

Help!


--
sunfish62
------------------------------------------------------------------------
sunfish62's Profile: http://www.excelforum.com/member.php...o&userid=24541
View this thread: http://www.excelforum.com/showthread...hreadid=381824