Forum Discussion
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...
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.
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.
Thank you so much Riny - the Pivot Table gives me what I want but it still counts the blanks. I can work around that though. Thanks again - appreciate your help.
