Trying to extract differences in one column

[Jerry]

I am attempting to extract differences/non cleared transactions on a list that has been imported from an SAP file
For example..
11.5
-11.5
21.0
22.5
-22.5

I want to right a formula that will be able to copy and pasted down another column to isolate the 21.00 in this example

thank
jerry

 

[Dave R.]

Maybe this will get you started; data starts in A4, put formula in B4 and
copy down.

=IF(OR(ABS(A4)=ABS(A3),ABS(A4)=ABS(A5)),"",A4)

I am attempting to extract differences/non cleared transactions on a list

that has been imported from an SAP file.

For example..
11.50
-11.50
21.00
22.50
-22.50

I want to right a formula that will be able to copy and pasted down

another column to isolate the 21.00 in this example.