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:
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 -->
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:
- identify the duplicates
- sum up the total for the duplicate copies of the same book
- delete the copies and leave only one line with the book name/author/and now TOTAL number of checkouts
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 -->