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: 82
Default Sort problem

Hi,

I have a spreadsheet with 8 columns of data. Dates are in columns d,e,and
f. I would like to be able to sort ascending on column e first only if a
date exists in this column, otherwise sort on column d. So I could have
several early dates in column d where say rows 2 thru 6 when column e is
balnk. Then where column e has a date in row 7 maybe thru 10 the dates would
be later than column d. Dates in columns e for the same row will usually be
greater than that rows date in column d.

thanks for you help in advanced
--
By persisting in your path, though you forfeit the little, you gain the
great.

 
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 Problem Abdul Shakeel Excel Discussion (Misc queries) 0 February 7th 10 12:22 PM
Sort problem Karen53 Excel Programming 6 April 14th 08 09:22 PM
Big sort problem Patrick Simonds Excel Programming 0 December 18th 06 05:25 AM
sort problem Mike Excel Programming 5 November 29th 05 07:45 PM
Sort Problem Patrick Simonds Excel Programming 3 November 26th 05 11:02 AM


All times are GMT +1. The time now is 09:49 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"