LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Sort Order with Dates & Text

Greetings,

I am trying to sort a column with dates & text in it. The problem is
the second cell. All of the cells have a date in them except for the
second cell, which has text in it. This row needs to stay in the same
position.

I am using three columns in my sort. If I could get a forth sort
criteria, I could use another column to exclude the rows that I don't
want to move.

Is there any way to do this?

If not, is there any other way to keep the second cell in column A
from moving?

Any help will be appreciated.

-Minitman
 
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
Can't sort cells in date order that contain dates created from arr StaceyJ Setting up and Configuration of Excel 3 February 5th 09 04:44 PM
How do you sort a list of dates into date order Tegwen Excel Discussion (Misc queries) 2 August 31st 05 02:04 PM
How do I sort dates stored as 1-Jun-05 in order of day & month stuckiniraq Excel Worksheet Functions 1 July 18th 05 08:38 AM
Can you sort text in a random order in Excel tbowden Excel Discussion (Misc queries) 3 February 1st 05 02:42 PM
Need to sort dates before 1900 in proper order sandage_2000 Excel Discussion (Misc queries) 3 January 8th 05 03:31 AM


All times are GMT +1. The time now is 02:30 AM.

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"