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.
|