Matching debits and credits from one column?

Hi there,

I am unable to find the best way to quickly sort a column (or if there is one way) by matching a debit and credit numbers together? Please see example, column C.
For example row 2 and row 3 match, 8.62 and (8.62).
Is there a quick way of doing this?

Regards

Nim

Thanks for this, It should help. Much appreciated for quick reply.

Great, glad it helps.

If your problem is solved, go to Thread Tools and select Mark This Thread Solved
Thanks.