Forum Discussion

Jacky_Keeling's avatar
Jacky_Keeling
Copper Contributor
May 11, 2023
Solved

Counting unique dynamic data

Hi Excellers Can anyone help me please? I have a list of data (Staff Initials) at the end of a sheet showing which people do that task example below   I would like to Count the occurrences o...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 11, 2023

    Jacky_Keeling Consider using a pivot table. See attached. 

     

    Add more staff ID's and press Refresh All on the Data ribbon. The Pivot Table gets instantly updated.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 11, 2023

Jacky_Keeling Consider using a pivot table. See attached. 

 

Add more staff ID's and press Refresh All on the Data ribbon. The Pivot Table gets instantly updated.

Resources