Forum Discussion
Shift note Auditor automation
Hi all in the Excel community. I have been auditing shift notes at work and have found massive problems with missing documents. I have to find out if staff have neglected to submit them , was the shi...
Cambosity100 I believe you don't need any of the intermediate steps to arrive at the small table in columns U:V in Sheet1.
If you clean the Directory data by getting rid of empty rows, you can put the entire list with Date, Status and Notes, in preferably, a structured table and run a pivot table on that one. Demonstrated in Sheet2 in the attached file.