Forum Discussion
Delete rows of negative and positive cells that cancel each other out - Exact Opposites
your formula is not working in my data since there are repetitive amounts of the same number
You do realize that just shy of 4 years (!!) have passed since the original question and the reply of JKPieterse ?
It might make more sense in this case to start afresh, especially since it sounds as if you have a slightly different starting point. If it's possible for you to do this, you could help us help you by posting a copy of your workbook (or a mockup that replicates the circumstances), putting the file on OneDrive or GoogleDrive and pasting a link here that grants access.
While you're at it, I'm curious -- this applies to the original question posted by Mark0987 four years ago as well -- if the numbers are cancelling one another out, what difference does it make? Asked a different way, what is it about the circumstance that makes it important to eliminate some of the numbers from the sum? I ask because I'm a person who always wants to be able to go back to the starting point, to verify or validate a process, to check the historical record. Eliminating actual data does away with that possibility, and could be problematic if, for example, one (or more) of the eliminated rows turns out to have been inaccurate in the first place and should have been retained.