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.
|