Forum Discussion
CREATING REPORTS IN MS EXCEL 2016
I have an EXCEL spreadsheet that contains the NAMES of the participants and the roles they played in an event on a selected day. I want to create a report which will summarize how many times that...
ExcelBossJock930 It sounds like you need a pivot table. Though, it's important that the data is structured correctly. Can you share a file perhaps? Use OneDrive or something similar, or at least insert a screenshot of the data you are dealing with. Just be sure to remove/change confidential information.
Perhaps the attached (rather abstract) example will help you get started.