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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Sorting #'s??
Step 1 - Highlight the list of numbers to sort, go to Data, Sort, and click
the descending box. That will put the whole #'s first. Step 2 - Highlight only the whole #'s then go to Data, Sort, and click the ascending box. That will put the whole #'s in order from smallest to largest. Hope that helped. "Missy" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Sorting #'s??
I tried but it's not sorting like you say. It puts them in the order that i
have them typed below .38, .62, 1, 1.29, 1.67, 2 Is there a setting somewhere that would make this work? "Kim17738" wrote: Step 1 - Highlight the list of numbers to sort, go to Data, Sort, and click the descending box. That will put the whole #'s first. Step 2 - Highlight only the whole #'s then go to Data, Sort, and click the ascending box. That will put the whole #'s in order from smallest to largest. Hope that helped. "Missy" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Sorting #'s??
Make sure when you go to Data, Sort, that you are selecting the Descending
box. It should sort from largest # to smallest #. Then go back and highlight just the whole #'s and resort with the Ascending box checked. Make sure you highlight what you want sorted. "Missy" wrote: I tried but it's not sorting like you say. It puts them in the order that i have them typed below .38, .62, 1, 1.29, 1.67, 2 Is there a setting somewhere that would make this work? "Kim17738" wrote: Step 1 - Highlight the list of numbers to sort, go to Data, Sort, and click the descending box. That will put the whole #'s first. Step 2 - Highlight only the whole #'s then go to Data, Sort, and click the ascending box. That will put the whole #'s in order from smallest to largest. Hope that helped. "Missy" wrote: 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. |
Reply |
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 |