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
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]Day 1[/TD]
[TD]Day 2[/TD]
[TD]Day 3[/TD]
[TD]Day 4[/TD]
[/TR]
[TR]
[TD="align: center"]Mr. X[/TD]
[TD="align: center"]X[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Mr. Y[/TD]
[TD="align: center"][/TD]
[TD="align: center"]X[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Mr. A[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]X[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Mr. B[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]X[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Mr. C[/TD]
[TD="align: center"][/TD]
[TD="align: center"]X[/TD]
[TD="align: center"][/TD]
[TD="align: center"]X[/TD]
[/TR]
</tbody>[/TABLE]