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!
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>