LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort last name order amolano8 Excel Discussion (Misc queries) 2 August 17th 06 06:24 PM
How do I do a random excel sort or shuffle, in no particular order terrih Excel Discussion (Misc queries) 2 April 3rd 06 05:40 PM
Formula to sort names in alphabetical order? Fredrik Jonsson Excel Discussion (Misc queries) 0 September 1st 05 04:33 PM
How do I make the sort default to 'No header rows' DJT Excel Discussion (Misc queries) 1 August 29th 05 11:40 PM
sort worksheets in numerical order andrew Excel Discussion (Misc queries) 2 February 7th 05 09:09 PM


All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"