Forum Discussion
Excel Filtering
sam735 I'd recommend you to look into the use of a pivot table, where you put the Unique ID in the Rows field as well as in the Values field (summarise by Count), and then filter it as you like.
Now, you may never have seen this but there are plenty of tutorials on line. Just google for "pivot table Excel". Attached workbook contains a very small and simple (unfiltered) example.
Hi Riny, thanks for your help. I've worked out how to use pivot tables and for 80% of the values it works but as can be seen in my screenshot, for one of the values, the pivot table has the count at 8 but then when I go to search for the number it can only find 7 instances of it. Do you know what I'm doing wrong? Thank you so much for your help!
sam735 Double-click on the 8 in the pivot table. It will open a new sheet with the underlying items. Should come up with 8 records. Can't really tell if something is wrong with the file.