How to create a list of unique dates?
On Thu, 14 Jun 2007 17:39:00 -0700, Eric
wrote:
[List of dates]
14-Jun,14-Jun,17-Jun,15-Jun,23-Jun,16-Jun,26-Jun,17-Jun,05-Jul,19-Jun
There is a list of dates under column A, does anyone have any suggestion on
how to create a list of unique dates as show below? but I don't want to use
Data, Filter, Advanced Filter. Does anyone have any suggestions?
Thank for any suggestions
Eric
[Unique dates]
14-Jun,15-Jun,16-Jun,17-Jun,19-Jun,23-Jun,26-Jun,05-Jul
Here's one way.
With your dates in a Named Range called Dates (e.g. A2:A11), enter the
following:
B2: =MIN(Dates)
B3:
=IF(AND(B2<"",COUNTIF(Dates,"<="&B2)<COUNT(Dates) ),
SMALL(Dates,1+COUNTIF(Dates,"<="&B2)),"")
Fill down as far as required.
Note that this will return a sorted list, as you gave in your example.
--ron
|