sorting/grouping positive and negative numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a friend who'd like to arrange information in a list of financial
data. In the list, there will be a positive and negative version of each
number (debit and credit). She would like to arrange the list such that the
debit and credit records are together. I had suggested sorting on a helper
column that used the ABS function, but is there any other method that might
work better?

Thanks in adavance!
 
Back
Top