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

Hi
perhaps use a helper column containing =ABS(A1) pulled down, then sort based on this helper column

__________________
Using O365 v2503 - 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