Match neg numbers to pos

[colmodoc]

Hi.
I'm searching for a solution to an accounts problem where I have one column.
That coulmn contains certain corresponding Dr & Cr numbers (1 negative & 1 Positive) that I need flagged for removal.
Help appreciated.
Colmodoc

[oldchippy]

Use a helper column, if your positive and negative numbers are in column A, put this in B1 and copy down

=ABS(A1) then sort your data based on this column

[colmodoc]

Very good. Many thanks.