hello, im a secretary for a small school.
i have an attendance sheet for classes and the dates.
i would like to see Present count per day per classes. but for some reason, i can only do 1 date at a time.
in the file im sharing, you will see 3 tabs.
"all data" all the data i collected
"pivot" is where i can only do 1 date at a time.
"desired result" is an example of the pivot data i actually want.
please help! thanks for your time everyone
www.kerrsbuilding.com/test/example.xlsx
i have an attendance sheet for classes and the dates.
i would like to see Present count per day per classes. but for some reason, i can only do 1 date at a time.
in the file im sharing, you will see 3 tabs.
"all data" all the data i collected
"pivot" is where i can only do 1 date at a time.
"desired result" is an example of the pivot data i actually want.
please help! thanks for your time everyone
www.kerrsbuilding.com/test/example.xlsx