#1
|
|||
|
|||
Sorting
I want to sort the following:
1 3 2 -1 When I sort I want the following: 1 -1 2 3 I want the numbers in order regardless if negative or positive. Can this be done? If so, how? Thanks for your help texascpa |
#2
|
||||
|
||||
Hi
perhaps use a helper column containing =ABS(A1) pulled down, then sort based on this helper column
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting Issus | MdCadle | Excel | 1 | 07-09-2013 11:44 AM |
Sorting Challenge | gbaker | Excel Programming | 11 | 06-22-2012 09:39 AM |
Sorting by certain criteria | randenius | Excel | 2 | 06-11-2012 02:18 AM |
sorting problem | gsrikanth | Excel | 4 | 02-16-2012 12:30 AM |
Sorting question | markg2 | Excel | 4 | 01-25-2010 03:13 PM |