An attendance plotting with help of a formula

PikK45

New Member
Joined
Sep 3, 2013
Messages
5
Hello all,

Can some one help me in the below case?

Now what I need is to find out who was absent on respective days. In the below chart, X denotes absence.

Day 1 = Mr. X
Day 2 = Mr. Y | Mr. C
Day 3 = Mr. A | Mr. B
Day 4 = Mr. C

Is there any way to achieve this with just formula?

I'm okay if this has to be split and done
Day 1Day 2Day 3Day 4
Mr. XX
Mr. YX
Mr. AX
Mr. BX
Mr. CXX

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,108,940
Messages
5,525,755
Members
409,664
Latest member
translatedotpink

This Week's Hot Topics

Top