Forum Discussion
Excel Filtering
Hi guys, I'm new to excel so any help is appreciated, I feel this is a fairly straight forward question but I haven't been able to work it out. Essentially I have a spreadsheet with information o...
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.