I feel as though I am missing something obvious here which is making me gnash my teeth. I'm attaching a sample Excel sheet here. There's a data entry sheet where training evaluations are to be entered (converted to a table).
I can get some data out of it but I'd like to construct a pivot table to show the following:
On the Attendance by Course sheet how can I get it to show the number of attendees for each course e.g. for Access Introduction it should be 3, (although for some reason it's not showing that,for Outlook 5, for Word Intermediate 4. I think it's something to do with the unique identifier I am using (I've experimented with adding an identifier for each record, a form identifier, a course identifier field)...but I feel as though I am missing something. As always your help is most appreciated :-) Training-Evaluation-data-sheet.xlsm