How can I filter a list with VBA?

's Computer Specifications

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.

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update Filter List AFTER Filter Applied	Robert Jacobs	Microsoft Excel Discussion	3	23rd May 2011 05:27 PM
filter: how to print filter list options in dropdown box	=?Utf-8?B?aGVscCBwbGVhc2U=?=	Microsoft Excel Misc	2	17th Oct 2007 01:53 AM
List Box used to filter a report in print preview, when make more than one selection it does not filter the selections.	Incolor	Microsoft Access Forms	2	25th Apr 2006 04:20 PM
Use input box to make filter choice while providing list of possible filter choices	GretOgrady	Microsoft Excel Discussion	3	20th May 2005 12:20 AM
Filter macro using criteria in a list (not autofilter drop down list)	Jeff Smith	Microsoft Excel Worksheet Functions	0	29th Jul 2004 10:06 PM