How to add equal values and than replace them with their sum?
 

I wonder if Excell could even do something like this. I have a range of
values (column A) and their respective cost in (column B). I need Excell to
find the same values in column A, add their cost in column B, and then
replace these values with their sum (column B) and possibly delete used lines
or mark what to delete manually. I am using Excell 2000 9.0.3821 SR-1. Thanks.