| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I filter a list with VBA?
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I filter a list with VBA?
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I filter a list with VBA?
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula (not adv. filter) to list unique values from list | Excel Worksheet Functions | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| How to filter list from pre-existing list | Excel Discussion (Misc queries) | |||
| Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
| How to filter a 2nd list based on selection in 1st list. | Excel Programming | |||
Hybrid Mode
