MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sort a column by absolute values !!!!!!!!!!


Posted by Adam K on September 20, 2000 8:14 AM

I need to sort a column ascending and descending by absolute val so for example:

3
6
-2
-5
4

would be sorted as
-2
3
4
-5
6

Any help please


Posted by Ben on September 20, 0100 9:41 AM

I would do it by adding a second column that contains the absolute values, and then sorting that column. You can use the ABS function to get the absolute values.

-Ben