I have a registration/attendance form which contains list of people that attended the the occasion from day1 through day 5. If anyone attended or missed any day, I put "P" for present or "A" for Absent under the each day i.e Day1 Day2 Day3 Day4 Day5
P A P P P
Now, I want to find for each day, the list of people with "P". I used this formula: =INDEX(Registration!B10:B159,MATCH("P",Registration!N10:N159,0))
On the first list for Day1, the first person on Row 1 (Larry) was present, the second person on Row 2 Kimberly was absent, the third person on Row 3 (Daniel) was present, Row 4 (Samuel) was present, and so on. Upon using the above formula, I got the name of the 1st person who was present, it skipped the 2nd person since she was absent but it put the name of the 3rd person in the 2nd and 3rd row. That is:
Larry
Daniel
Daniel
Samuel
I want the formula not to repeat names, but to skip to next as long as the person is absent. I need help.
Thank you.
Bookmarks