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.
James_Raju If you are open to a solution using Power Query (PQ) and Pivot Tables, please see attached. No need for COUNTIF, SUMIF etc. And you have the possibility to count distinct occurrences of meetings. Must say that I'm still a beginner in the area of PQ (coming from an Excel for Mac background), so a real expert in this area can probably make it nicer.
This is exactly what I wanted! I'm fairly new to excel and haven't gotten around to using Pivot tables and such. Is there a way for the Pivot table to update itself every time I update or add more information to the set? I've tried adding more data but the values on the table remain the same. Is there any way I can get it to include this new data into the results without having to make a new table each time?
Many thanks!
James Raju
