How to create a list of unique dates?
Hi Eric:
In B1 thru B10:
14-Jun
14-Jun
17-Jun
15-Jun
23-Jun
16-Jun
26-Jun
17-Jun
5-Jul
19-Jun
In A1 put a 1
In A2 put:
=IF(COUNTIF($B$1:B2,B2)1,"",ROW()) and copy down to see:
1 14-Jun
14-Jun
3 17-Jun
4 15-Jun
5 23-Jun
6 16-Jun
7 26-Jun
17-Jun
9 5-Jul
10 19-Jun
notice duplicates have blanks in col A
in C1 put:
=VLOOKUP(SMALL(A$1:A$10,ROW()),$A$1:$B$10,2) and copy down to see:
1 14-Jun 14-Jun
14-Jun 17-Jun
3 17-Jun 15-Jun
4 15-Jun 23-Jun
5 23-Jun 16-Jun
6 16-Jun 26-Jun
7 26-Jun 5-Jul
17-Jun 19-Jun
9 5-Jul
10 19-Jun
All items in C are unique. This technique will work with dates, numbers,
words, etc.
--
Gary''s Student - gsnu200729
"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
|