Thread: Sort problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DavidH56 DavidH56 is offline
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.