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 |