Hi please can someone help me, I am a complete novice with Pivot Tables, I think it is a pivot table which is the best to use.
I want to be able to click a surname and then have Excel show all the events they attend. I also want to be able to click an event and see all the people that are attending.
I also need to be able to do a count for each, ie click on a person and see the count of the number of events they are attending and vice versa.
I have attached a spreadsheet with the names changed and a trail pivot table.
Many Thanks,
Chris
Bookmarks