Week-Off Days name

[jsmithjames03]

Hi,
Please help me to solve the issue. I have an employee's weekly roster, and I need a simple report to find the week-off day based on the employee name.

 

[Belleke]

Something like this?

 

[jsmithjames03]

Something like this?

Thank you for your response.
But sorry, my requirement is a little bit different like this:

Emp Name	WO 1	WO 2
Krishna	Tue	Fri
Biswaraj	Mon	Thu
Aditya	Wed	Thu

 

[Belleke]

Good luck with this set up. Suc6

 

[p45cal]

Clear cells B15:C17, then in cell B15:

=FILTER($B$2:$F$2,INDEX($B$3:$F$5,MATCH(A15,$A$3:$A$5,0),)="WO","None")

and copy down.

 

[jsmithjames03]

Clear cells B15:C17, then in cell B15:

=FILTER($B$2:$F$2,INDEX($B$3:$F$5,MATCH(A15,$A$3:$A$5,0),)="WO","None")

and copy down.

Excelent. Thank you.