I have an excel sheet that has duplicates in it. To the right of the duplicates are two columns, each contains a number. What I need is to get rid of the duplicates and give a total sum for each duplicate.
car 2 4
car 3 6
car 4 2
so after you are done, it would simply say
car 9 12
I have a list of 5,000 items this needs to be done in and its in excel. Will pay someone $30 to get it done. Easy if you know excel :-)