| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert the amount in currency into the amount in words? | Excel Discussion (Misc queries) | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Threaded Mode
