Forum Discussion
Delete rows of negative and positive cells that cancel each other out - Exact Opposites
Is there a way that I could delete rows that are exact opposites & net to zero? Keeping only the numbers that are affecting the overall balance. For example - -100 -200 50 100 200 In t...
Suppose you have A2:A1000 filled.
Enter this formula in any adjacent column:
=COUNTIF($A$2:$A$1000,-A2)
Copy the formula down to match the # of rows filled
Filter the table to hide zeroes (uncheck zero in the list or select "Number filters", "Not equal to" and enter a 0).
Delete all visible rows and remove the filter.
Enter this formula in any adjacent column:
=COUNTIF($A$2:$A$1000,-A2)
Copy the formula down to match the # of rows filled
Filter the table to hide zeroes (uncheck zero in the list or select "Number filters", "Not equal to" and enter a 0).
Delete all visible rows and remove the filter.
your formula is not working in my data since there are repetitive amounts of the same number