Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the sort completed automatically through vba. How do you tell the
sort to only do the numbers? "Jim Cone" wrote: Sort all of your data ascending. That puts the numbers at the top. Then sort just the rows with the numbers descending. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Jeff G" wrote in message I have data that is a mix of numbers and text that is being sorted. The text is always the same "NO DATA SUBMITTED". I need to sort the data showing the numbers in decending order at the top of the list. If I sort the data range in decending fashion, the text is brought to the top because of the default sort order. Any ideas on how to do this? Can the default sort order be changed for this worksheet only? Any ideas on other ways to do it would be appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sort last name order | Excel Discussion (Misc queries) | |||
How do I do a random excel sort or shuffle, in no particular order | Excel Discussion (Misc queries) | |||
Formula to sort names in alphabetical order? | Excel Discussion (Misc queries) | |||
How do I make the sort default to 'No header rows' | Excel Discussion (Misc queries) | |||
sort worksheets in numerical order | Excel Discussion (Misc queries) |