Please help. I have a large spreadsheet about 1500 rows. This is how the amount column looks like
123
-123
554
-333
-554
145
-145
234
My question is how can I match the numbers that look the same, except one is a positive number, and the other is a negative number ( ex:123 and -123) Once these numbers are identified I want to delete both of them and at the end my total will be left with only numbers that can’t pair with other numbers.
Your help in this matter is greatly appreciated.
Chom
The Excel function you want is ABS()
To compare two numbers in cells A1 and A2 irrespective of sign, use this formula:
=IF(ABS(A1)=ABS(A2),”Equal”,”Not equal”)
If you want help on the rest of the issue, some more information would help.
Are there ever more than one match, say:
If so how are these handled.
Do you want your list of unmatched values in a different location, or do you want them in the same place.
Is this a one time or occasional process where it is OK to go through a few steps to get the results,
or
Is this a frequent process that would benefit from automation with a macro (with it’s associated overhead of entering code, and managing it if circumstances change)
Regards