Thread: Merging duplicate rows, but summing a particular column.

Hi everyone!
I have spent the last hour trying to find a solution to my problem, and I just cannot find one that works, but I know it is out there.
I currently have an excel spreadsheet with roughly 10000 rows and about 10 columns.
There are duplicate rows, and every column has the identical value with the exception of the "amount" column.
I need to merge these duplicates, but add the values in the "amount" column.

My spreadsheet looks like this:
Company | Street | City | State | Amount
John, Inc. | 125 Marshall Street | Philadelphia | PA | 125.00
John, Inc. | 125 Marshall Street | Philadelphia | PA | 65.00
John, Inc. | 125 Marshall Street | Philadelphia | PA | 130.00
Mike's Co. | 5349 9th Street | Exton | PA | 45.00
Mike's Co. | 5349 9th Street | Exton | PA | 66.00


I want it to look like this:
Company | Street | City | State | Amount
John, Inc. | 125 Marshall Street | Philadelphia | PA | 320.00
Mike's Co. | 5349 9th Street | Exton | PA | 111.00

I tried pivot tables, and I cannot figure it out.
Please, any advice or solutions would be GREATLY appreciated. '

Thanks,
Jon

Hi Dave,
Thank you so much for offering your help.

I understand about using an advanced filter, but it still seems to give me duplicates of the company. I think this may be because each entry has a separate date (which I do not care about, I could use the most recent date per company). I am not educated on what a vlookup is or how to set it up properly.

I have posted a sample workbook. If you are able to take time to set it up, I would greatly appreciate it. If not, thank you so much for the advice you have already given me, and I will try to learn more about vlookups.

Thanks again,
Jon

Dave,
This is amazing work. Thank you VERY much for your help with this.
I am studying the spreadsheet now to learn more about Vlookups so I can recreate this in the future.
You saved me many more hours of frustration...I really appreciate it.

Thanks,
Jon