Sorting numbers
 

Hi

Hi have a column with negative numbers, zeros and positive numbers.
How can I sort it in a way that sort it in the following way, positive
negative and then zeros

regards,
Pedro

Sorting numbers
 

Use a helper column. If your data is in column A, then in B1 enter:
=ABS(A1) and copy down
then sort cols A & B by B and then by A
--
Gary''s Student - gsnu200793


"Pedro" wrote:

Hi

Hi have a column with negative numbers, zeros and positive numbers.
How can I sort it in a way that sort it in the following way, positive
negative and then zeros

regards,
Pedro