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