ordering

[Dave B]

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.

 

[Tom Ogilvy]

In B1 replace your formula with

=Small(Sheet1!$A$1:$A$6,row())

then drag fill down the column to B6

 

[Dave B]

Thanks Tom.

In B1 replace your formula with

=Small(Sheet1!$A$1:$A$6,row())

then drag fill down the column to B6