extract all the products mentioned in a column

[saadeet]

If you have a list of 2000 entries. The list contains orders for products. The same products can appear various times. The product range changes often.
Is it possible to make a function where it extracts the names of the products that appear on the list. The list should just contain the name of the each product once even though it appears several times in the column.
So you can see which products have been ordered. Only the names are needed.
thanks in advance

[Flintstone]

Hello Saadeet:

This works if the product names are the only things listed in column A.




Matt

[davesexcel]

This seems like a similar question

http://www.excelforum.com/showthread.php?t=589953

[saadeet]

Thx guys. Could not get the excel sheet you sent to work Flintstone. Just came out as #VALUE!! in every square.
Used the function filter as suggested in the other thread posted by davesexcel. So thx a lot.

[saadeet]

I found out that the filter doesn't update automatically, so I need another solution.
@Flintstone
Can you help me out with the spread sheet you uploaded. In the C-column I only get #Value!!. And the formular is a little to advanced for me to understand.

[davesexcel]

I found out that the filter doesn't update automatically, so I need another solution.
@Flintstone
Can you help me out with the spread sheet you uploaded. In the C-column I only get #Value!!. And the formular is a little to advanced for me to understand.

Hi Saadeet,
I opened Flintstone's file and it works fine for me, I wonder what the problem from your end could be...........