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 (duplicate negative and positive numbers ) and remain with the ones that don't
2 Replies
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.
Hi changu92
Please see the below formula can be helpful, if you can attached few sample data with your desired result that would be great
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
