Grouping Sizes in Excel

[gemmavine]

Hi

I was wondering if anyone knows a quicker way of doing this...
I have an excel spreadsheet with lots of product codes in column a, description in b, and qty in c some are just individual items ie. soapbar, however, other items have sizes i.e trousers, coats, jackets. Is there a quick way of grouping all the sizes together. At the moment I am having to manually do it.

e.g.
SOAPBAR 1
TRSYM 10
TRSYL 3
BLEACH 4
STAPLES 6
JACKETM 1
JACKETXL 2


I would like the spreadsheet to look like this;
SOAPBAR 1
TRSY 13
BLEACH 4
STAPLES 6
JACKET 3

This would make life a lot easier as I am dealing with thousands of records.
Thanks

Gemma

 

[UniMord]

Let's assume your products column is named Products, and your quantity column is named Quantity.

If you'll create your list of items without the sizes starting at E2, then in F2, you can enter: =SUMIF(Products, E2 & "*", Quantity)
Copy down, and voila!