An attendance plotting with help of a formula

[PikK45]

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 1	Day 2	Day 3	Day 4
Mr. X	X
Mr. Y		X
Mr. A			X
Mr. B			X
Mr. C		X		X

<tbody>
</tbody>