Im having a column with numbers... a lot of these number are exactly the same except that they are negative/postive so the sum of them will be 0


is there any way I can make a macro which wil indetify to cells which will qual eachother out to 0?


-1500
-1000
-1000
-200
-100
-30
20
30
99.5
1000
1500

on this list above, these numbers will equal each other out:

-1500 + 1500 = 0
-1000 + 1000 = 0
-30 + 30 = 0


All help apprichiated.