Forum Discussion
changu92
Mar 13, 2020Copper Contributor
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...
Mar 13, 2020
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
If you find the above solution resolved your query don't forget mark as Official Answer.