|
|
Thanks I will try that
"dominicb" wrote:
Good evening BangBanjo
The only way I can think of doing this using the Excel sort function is
to have an additional column inserted to use a sort key. If your data
is in column A, starting at A1, put in column B1 =ABS(A1) and copy it
down. This will give the absolute value (ie ignore minuses) and use
this as your sort key. As this column is a formula it will change as
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
DominicB
--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=376939
|