Forum Discussion
How to remove figures that zero out in are large work sheet
I need help on how i can filter or remove entries that zero out (567,-567,8976,-8976) from a spreadsheet of over 30000 entries, basically i want to remove all duplicate figures that zero out (duplica...
changu92 I googled around a bit and came to this site:
https://www.myonlinetraininghub.com/excel-bank-reconciliation-formula
It offers a clever solution to the issue, which I might use myself in the future. I adopted it a little bit by using the modern day FILTER function. Please see attached. If your Excel doesn't recognise FILTER (yet), you can implement the last step in the link yourself.