I have a muster extract, wherein we have the columns as dates and the rows are their presentee status e.g. Absent or Present.
I want to filter rows whereever there is AB mentioned for each and every employee and have only those rows displayed. So that I can email them and they can act on it.
Attached is a spreadsheet with raw data, the second tab is the example of the desired result. I should have that for every employee as tabs or different excel whichever is easier.
Thanks much for your help
MusterRoll_Sample.xlsx (17.0 KB)