Hi all
I have a pivot table that generates a list of staff that have completed timesheets for eaqch day of the month and the hours booked. The number of entries on each day will vary accoring to whether a timesheet has data on it or not - so for example, on one paricular daythere may be 3 people who have not started to complete a timesheet so their name does not appear at all.
I want to be able to compare the pivot tyable results, for each day of the month, to a static column that has a list of all staff names and on each day of the pivot table output the names of staff that have not completed a timesheet entry for that day.
What is the best way of doing this?
Cheers
Arun
I have a pivot table that generates a list of staff that have completed timesheets for eaqch day of the month and the hours booked. The number of entries on each day will vary accoring to whether a timesheet has data on it or not - so for example, on one paricular daythere may be 3 people who have not started to complete a timesheet so their name does not appear at all.
I want to be able to compare the pivot tyable results, for each day of the month, to a static column that has a list of all staff names and on each day of the pivot table output the names of staff that have not completed a timesheet entry for that day.
What is the best way of doing this?
Cheers
Arun
