| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting numbers and numbers that contain text in excel | Excel Discussion (Misc queries) | |||
| Sorting high numbers from low numbers between two rows | New Users to Excel | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| Sorting numbers with differing numbers of digits | Excel Discussion (Misc queries) | |||
| Sorting texts and numbers as if it was all numbers | Excel Programming | |||
Linear Mode
