Sort ignoring negatives and positives

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

Guest

I need to sort a column of number values by the value ignoring negatives and
positives. Example take the list:

-5000
-4000
-1500
1500
4000
5000

and sort into this list
-5000
5000
-4000
4000
-1500
1500
 
You would need a help column, you can insert a temporary help column and use
a formula like


=ABS(A1)


copy down, select both columns and sort by the help column descending


--
Regards,

Peo Sjoblom

(No private emails please)
 
Good evening BangBanjo

The only way I can think of doing this using the Excel sort function i
to have an additional column inserted to use a sort key. If your dat
is in column A, starting at A1, put in column B1 =ABS(A1) and copy i
down. This will give the absolute value (ie ignore minuses) and us
this as your sort key. As this column is a formula it will change a
the data in column A changes and could be hidden if required.

Or you could write a macro to do this without the intermediate step...

HTH

Dominic
 
Back
Top