Find duplicate rows and add together

[Guest]

Hi, I know this question is a little repetitive, but I can't find the exact
answer.
I have a sheet that has a list of all style numbers that we offer, how many
were sold, and the dollar amount. The info is from 6 different shows, so i
have duplicates. How do I recognize the duplicates and have the dollar
amount and quantity added while deleting the others?

EX
A B C
ES5666 34 $400.
ES5666 26 300.
ES8900 5 150.

I need it to look like this.....

A B C
es5666 60 700
es8900 5 150

 

[Dave Peterson]

You could use Data|Pivottable.

Add a single row of headers to your data (if you don't have them now).
select your data A1:C9999 (through the bottom right corner)
Data|pivottable (actually, this menu item changes captions with versions of xl)
follow the wizard
(just click Next until you get to a dialog that has a Layout button on it)
click that Layout button
Drag the header for the style to the Row field.
drag the header for the qty to the data field
drag the header for the dollar field to the data field

If you see "Count of qty" or "count of Dollar" then double click on that one and
change it to Sum
(sum of qty, sum of dollar)

click ok and finish

Now drag the grey button labelled Data over one cell to the right and let go.
(Yep, right on top of the word Total!)

Tada!

If you want to read more about the pivottable stuff, you may want to look at
some links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx


===========
Alternatively (uglier):

Sort your data by the Style column.
Data|subtotals
subtotal by style

Then use the outlining symbols on the left to hide the details.

You could even select that range
edit|goto|special|visible cells only
and copy it
then paste to a new sheet.