Sum duplicate values then delete duplicate rows

IrinaChukhray

New Member
Joined
Nov 1, 2008
Messages
5
<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1><!-- / icon and title --><!-- message -->Hi. I have Windows XP, Microsoft Office 2003 (Excel 2003)



I have over 20,000 items that I must sort through. I am dealing with book titles and need to sort them by how many times each book has been checked out. But there are often several copies of books so I need to do the following in excel:
  1. identify the duplicates
  2. sum up the total for the duplicate copies of the same book
  3. delete the copies and leave only one line with the book name/author/and now TOTAL number of checkouts
Here is a sample of what my data looks like:

Column A______________________ Column B_________ Column C
Title Author Checked Out
1 gaping wide-mouthed hopping frog ___Tryon, Leslie ________114
4 pups and a worm __________________Seltzer, Eric ________135
A bade case of stripes _______________Shannon, David _____102
A bargain for Frances ________________Hoban, Russell ______131
A bargain for Frances ________________Hoban, Russell ______107
A bargain for Frances ________________Hoban, Rusell _______102
A bear for all seasons ________________Fuchs, Diane _______103
A bear for all seasons ________________Fuchs, Diane_______ 102


There are two duplicates for "A bargain for Frances" and one duplicate for "A bear for all seasons. Here is what I would like for it to look like:

Column A ____________Column B ___________Column C
A bargain for Frances ____Hoban Russell __________340
A bear for all seasons ____Fuchs, Diane___________ 205

Is there a way to do this? I know how to do it manually through the Conditional Sum Wizard but I have so many items that it would take literally forever. Is there a way to have excel to do in one shot? Some kind of formula?

If you guys can, please provide instructions step by step...in the past I have used excel for only very general things. So writing formulas, even COUNTIF or SUMIF was totally new to me as of only a few weeks ago.

thank you so much for your help!
Irina
<!-- / message -->
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You could use a pivot table to have a summary snapshot of the data - this way your original database will remain intact.
 
Upvote 0

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top