| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Sorting #'s??
If I have a list of numbers - say .38, .62, 1, 1.29, 1.67, 2, etc.
How can I sort the list to have the whole numbers first, (1, 2) then the list of other numbers? If I data sort it puts them in the order I have listed. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced filtering on text and blanks | Excel Discussion (Misc queries) | |||
| sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
| Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
| sorting number in ascending order | Excel Discussion (Misc queries) | |||
| SORTING question | New Users to Excel | |||
Threaded Mode
