Forum Discussion

ExcelBossJock930's avatar
ExcelBossJock930
Copper Contributor
Jul 06, 2022

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

 

excel

1 Reply

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 06, 2022

    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.

Resources