Dupilicate entries amount to be added
Dear Mate,
I need your help, i have 8000+ company names with their revenue. There are
duplicate names but the revenues are unique which needs to be added togather.
Finally i need only one company name with added revenue Like Col C & Col D
For example
Col A Col B Col C Col D
500 Dave & co.
400 Dave & co.
200007 Dave & co. 200907 Dave & co.
67.97 Ford & sons
9272.9 Ford & sons
18477.83 Ford & sons
27682.76 Ford & sons
36887.69 Ford & sons 92389.15 Ford & sons
46092.62 Goodwill
55297.55 Goodwill
64502.48 Goodwill
73707.41 Goodwill 239600.06 Goodwill
Regards
Mat
|