Thread: ordering
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave B[_3_] Dave B[_3_] is offline
external usenet poster
 
Posts: 25
Default ordering

Hey gurus,

I have a list of dates in cells A1:A6

06/30/2002
06/30/2002
06/30/2005
06/30/2005
06/30/2000
06/30/2003

In cell B1 on the next worksheet, I have =MIN(Sheet1!A1:A6), which in this
case equals 06/30/2000. I want to use a single formula in the cells below
B1 to order the rest of the dates so that cells B1:B4 on the second sheet
will display, in order

06/30/2000
06/30/2002
06/30/2003
06/30/2005

Can this be done with a single formula? Thanks.