Create a simple dynamic tally chart via dropdown list WITHOUT a Pivot Table

shade206 so this is one of many things that a pivot table can do for you.  I have attached your book updated with a) using a COUNTIFS() formula next to the manual table you created, b) with a pivot table using User ID as a Filter criteria, c) pivot table showing the results with all the User IDs (and a slicer), and d) I also added a "Uniq Users" drop down that uses a dynamically created list of all unique IDs from the data tab that have the character/strings that you start typing in that c6 drop down list. (i.e. you type "3" and then click the drop down it will only show ID 313 since that is the only ID with a "3" in it.  I didn't connect anything to this drop down box but included it for show.