Default Sort Order

[Guest]

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.

 

[Jim Cone]

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" <[email protected]>
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.

 

[Guest]

I have the sort completed automatically through vba. How do you tell the
sort to only do the numbers?

 

[Jim Cone]

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" <[email protected]>
wrote in message
I have the sort completed automatically through vba.
How do you tell the sort to only do the numbers?

 

[Richard Buttrey]

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

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
__________________________