Forum Discussion
Need help counting distinct values
James_Raju The file I sent you uses Pivot Tables based on a your data that gets "manipulated" in Power Query. I created a dynamic named range of your data table. When you add data and refresh the query, everything should update instantly. On the Data ribbon you should find an icon "Refresh All". Try and see what happens. Would advise you, though, to learn about Power Query.
If you are on a modern version of Excel that supports the functions UNIQUE and FILTER, you might want to use them in stead in your existing table that already works for the attendee count. I've attached a revised file for your reference.
Hi!
Thanks for the help!
The data set contains details of 52 meetings in total (example: Meeting No. 1 in S.no 2 to 232 is the same meeting). I need help counting the number of meetings held in each location.
James_Raju see attached. I listed all the meetings. Now you can see the count for each meeting. It counted the staff number and meeting
jukapilHi !
I'm really sorry buddy! It's still not what I was looking for. I would like to know how many meetings were held in each location. For example: 1 Press Meeting and 5 Staff meetings were organized in location 1. I arrived at this by filtering the data and excluding duplicates, but I had to do that manually. I need another, hopefully 'automatic' method of getting this information.
Appreciate the help,
James Raju
