| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter a list using a formula.
i have a list of names in column A15:A1014. The names will appear more than
once in the list. I want to filter this list into another column AQ15:AQ1014 so that only unique enteries are shown, but i want this as a formula rather than using the advance filter option so that as the data changes in the first column it is automatically updated in the second column. Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Filter a list please help | 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 | |||
| Filter List | Excel Discussion (Misc queries) | |||
Threaded Mode
