+ Reply to Thread
Results 1 to 6 of 6

extract all the products mentioned in a column

  1. #1
    Registered User
    Join Date
    03-20-2006
    Location
    Malaga, Spain
    Posts
    39

    extract all the products mentioned in a column

    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

  2. #2
    Forum Contributor
    Join Date
    10-14-2004
    Location
    San Diego, CA
    Posts
    213
    Hello Saadeet:

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




    Matt
    Attached Files Attached Files

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,140
    This seems like a similar question

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

  4. #4
    Registered User
    Join Date
    03-20-2006
    Location
    Malaga, Spain
    Posts
    39
    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.

  5. #5
    Registered User
    Join Date
    03-20-2006
    Location
    Malaga, Spain
    Posts
    39
    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.

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,140
    Quote Originally Posted by 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.
    Hi Saadeet,
    I opened Flintstone's file and it works fine for me, I wonder what the problem from your end could be...........

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1