a list exactly like you get on the drop-down when filtering data).

Since you mentioned filter, use the advanced filter to extract the uniques
to another location.

Select the column of data (should have a column header or Excel will
complain).
Goto the menu DataFilterAdvanced filter
Copy to another location
List range: the source range of your data (should already be entered)
Copy to: cell reference where you want the new list to start
Unique records only
OK

--
Biff
Microsoft Excel MVP


"Terry Bennett" wrote in message
...
I have a large data table. In column A (say A1:A10000) there will be
random occurrences of particular items of text, ie:

Oranges
Apples
Pears
Grapes
Peaches
etc
etc

Obviously I can count how many times each item occurs using COUNTIF or
SUMPRODUCT but how do I extract a simple list of all the different types
of items? I just need a list as above, ignoring the fact that any one
item may occur several hundred times (ie; a list exactly like you get on
the drop-down when filtering data).

Thanks in advance.