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!
Bookmarks