Sorry I didn't give it to you in VBA (misread your post) but I'd just record
the advanced filter and take a look at the result.

Kevin

"dunnerca" wrote:

Use Data Filter Advanced Filters. Indicate that you want to copy the data to
another location (click on the cell where you want it to go) and also make
sure you check the box "Unique Records Only". You don't need a criteria
range specified.

Kevin

"ChipButtyMan" wrote:

Hi,
I have a column of dates in no particular order. Some dates are
repeated over and over.
I want to return a list of all the different dates in ascending order
to the next adjacent column.
For example;

Dates Result
16/10/2008 12/10/2008
16/10/2008 13/10/2008
16/10/2008 15/10/2008
15/10/2008 16/10/2008
15/10/2008
12/10/2008
13/10/2008
16/10/2008
12/10/2008
16/10/2008

Thank you for your help.