Insert a new worksheet, and then copy your data items from A1:A10000
into column A of the new sheet. If you do not have a header, then
insert a new row at the top and put some text in A1 to act as a
header. Then highlight from A1 down to the bottom of your data and
click on Data | Filter | Advanced Filter, and in the pop-up select
Unique Records Only, Copy to another location, and enter C1 in the
other location box. Click OK and you will find your list of unique
values (plus the header) in C1 onwards. Delete columns A and B.

Hope this helps.

Pete

On Jan 14, 10:14*pm, "Terry Bennett"
wrote:
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.