Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting/grouping positive and negative numbers
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting/grouping positive and negative numbers
I would use Jim Cone's fine commercial Add-in for this task. It's available
at http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "Stephen" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
Compare Negative & Positive Numbers | New Users to Excel | |||
how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) |