Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find duplicate rows and add together
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 |
#2
|
|||
|
|||
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/assistan...lconPT101.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. DaleM wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|