Merge (Deduplicate) Like Records - FreeTutorialExcel.com
http://www.freetutorialexcel.com
When using an MS Excel worksheet as if it were a database table, in many cases you will want to have only one record per unique identifier, such as Customer ID, Order ID, or customer name. However, at the same time, you may have one field in the record that contains data (e.g., Revenue) that needs to be added (summed) if you merge the records. Here is how to do this using Pivot Tables.
http://www.freetutorialexcel.com