sorting/grouping positive and negative numbers

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with positive and negative numbers 1
Sorting negative numbers? 3
Delete all negative numbers leaving only positive numbers 8
Converting a negative number to a positive number 3
Excel - Adding positive or negative numbers in a column 5
Negative times 8
Negative Numbers 8
Add sequences of positive then negative numbers 6

Top