Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Default Sort Order
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Default Sort Order
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Default Sort Order
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Default Sort Order
Find the last row with a number in it (probably using a loop) and then
specify the numeric range when doing the second sort.. -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "Jeff G" wrote in message 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Default Sort Order
You could use a helper column and put in B1
=IF(LEFT(A1,2)="NO",MIN($A:$A)-1,A1) and copy down Now sort on column B descending. HTH On Fri, 1 Sep 2006 09:59:02 -0700, Jeff G wrote: 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. __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |