Sort a large file then sum like values...

[Guest]

hey guys, I'm not sure if what I would like to do is possible or not.
Basically, every week I put out a list of every different variation of
product that will be produced over the next eight weeks. The problem I run
into is that over the course or eight weeks, some product variations repeat
numerous times. Right now, I have to manually combine each variation across
the eight weeks via cutting and pasting then deleting the now empty row. Is
there any way to sort the file, then have excel combine the rows and delete
the rows that become empty?

About the file we use:

Rows are as follows:

Production line: Product description: Wk 1 : Wk 2:... Wk 8: Total:

The file is about 500 different variations long.

Thanks for any help you can provide!

 

[Guest]

Rather than sorting and messing with the original file, how about using Data
| Advanced Filter to generate a list of unique Product Line & Product
Description combinations, probably on a new sheet. Once you've done that,
and assuming that Lines are in column A, descriptions are in B, Weeks 1-8 ore
in C:J, all on Sheet1, then use this formula on Sheet 2, in cell C2 (first
row has column headings, right?):

=SUMPROUCT(--(Sheet1!$a$2:$a$1000=$a2),--(Sheet1!$b$2:$b$1000=$b2),Sheet1!$c$2:$c$1000).

Then copy the formula to all the appropriate cells

 

[Guest]

Thanks Duke, I will give it a shot later this week when I make the file!