CREATING REPORTS IN MS EXCEL 2016

New Contributor

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 person performed that role and on what date.

 

What is the best way to do this?  The YOUTUBE videos are either too confusing or don't work with my version of EXCEL.

 

Thank you.

 

Norm

 

1 Reply

@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.