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.

ordering
 

In B1 replace your formula with

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

then drag fill down the column to B6

--
Regards,
Tom Ogilvy


"Dave B" wrote in message
...
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.

ordering
 

Thanks Tom.


"Tom Ogilvy" wrote in message
...
In B1 replace your formula with

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

then drag fill down the column to B6

--
Regards,
Tom Ogilvy


"Dave B" wrote in message
...
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.