Results 1 to 5 of 5

Thread: How to assign categories to multiple duplicates?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2014
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to assign categories to multiple duplicates?

    The snippit veiw spreadsheet below shows the total sales of products for 2013.

    Column G displays the product codes that have been sold (there are duplicates throughout as the data is compiled of the individual orders)
    I would like to segment the products into their relevant categories in column ‘I’.

    Question:

    How do I assign a category to every product in column ‘I’?

    I think I would somehow need to list all of the product codes (minus duplicates) then assign the categories to each individual product in column ‘I’

    I would then need the duplicates in column ‘G’ to be assigned to their appropriate category in column ‘I’

    e.g. all of the ‘ER32SET’s in column ‘G’ should display ‘cutting tools’ in column ‘I’?

    I need to do this for every product in column ‘G’

    Your help would be greatly appreciated. A step by step guide would be great! I am an excel novice!

    Stock Code Short Description Product category
    BT40ER25 BT40 ER Chuck Range
    ER25SET ER Collets (class2)
    ER25SET ER Collets (class2)
    ER32SET ER Collets (Class2)
    ER32SET ER Collets (Class2)
    ER16SET ER Collets (Class2)
    ER25SET ER Collets (class2)
    ER32SET ER Collets (Class2)
    ER3210 ER Collects(Classs 2
    ER3212 ER Collets (Class2)
    ER3216 ER Collets (Class2)
    ER326 ER Collets (Class 2)
    ER32SET ER Collets (Class2)
    ER3211 Gurkan ER32 11mm Col
    ER3213 Gurkan ER32 13mm Col
    ER3214 Gurkan ER32 14mm Col
    ER324 Gurkan ER32 4mm Coll
    ER325 Gurkan ER32 5mm Coll
    ER327 Gurkan ER32 7mm Coll
    ER328 Gurkan ER32 8mm Coll
    ER329 Gurkan ER32 9mm Coll
    BT40ER32 BT40 ER Chuck Range
    BT40ER32 BT40 ER Chuck Range
    ER166 ER Collets (Class2)
    ER112 ER 11 Collet 2mm
    01-108-10NB Mixed Quality Wipers
    03-315-10NB White Sheeting
    03-316-5 White Sheeting
    0901 Aerosol White Linema
    0902 Aerosol Red Linemark
    0904 Aerosol Blue Linemar
    5084918 HM BRUSH CLEANER & T
    5084918 HM BRUSH CLEANER & T
    5084845 Hammerite 2.5Ltr Smo
    5084845 Hammerite 2.5Ltr Smo
    5084918 HM BRUSH CLEANER & T
    5084921 Hammerite 2.5Ltr Thi
    5084918 HM BRUSH CLEANER & T

  2. #2
    Board Regular
    Join Date
    Aug 2011
    Location
    AMS
    Posts
    1,911
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to assign categories to multiple duplicates?

    you should create a list with product/categories on another sheet and do a vlookup to this table

    otherwise how do you know under which category is which Product number?

  3. #3
    New Member
    Join Date
    Apr 2014
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to assign categories to multiple duplicates?

    Quote Originally Posted by hippiehacker View Post
    you should create a list with product/categories on another sheet and do a vlookup to this table

    otherwise how do you know under which category is which Product number?
    Thank-you for your speedy response.

    How do I create a list of individual products? I would need to remove the duplicates.

  4. #4
    Board Regular
    Join Date
    Aug 2011
    Location
    AMS
    Posts
    1,911
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to assign categories to multiple duplicates?


  5. #5
    New Member
    Join Date
    Apr 2014
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to assign categories to multiple duplicates?

    Quote Originally Posted by hippiehacker View Post
    Fantastic

    Thank-you

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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