Hi, running PowerPivot in excel 2016, say I have a group of 10 persons, and for every day the 10 persons record a score. I'm wanting to find how many days (or rows given that each row is a different day for the individual person) since each person recorded a score of say 60. So in the example...
I have a table, pasted below, which shows the daily cover status for different areas at work.
I need a way (perhaps VBA) to automatically print / generate a table showing:
1) Today only
2) Listing the ones without cover in the AM
3) Listing the ones without cover in the PM