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 worksheet with different names. Each name might have 1 to 5 rows with comments. I want all the comments on the first line. For example:
SSN NAME COMMENT COMMENTATOR
001 PERSON1 COMMENT1 JUDGE1
001 PERSON1 COMMENT2 JUDGE2
002 PERSON2 COMMENT1...
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