I have an excel file with 38,000 lines.
This file is broken up in two columns. Words and Numbers.
For the words columns I need all the duplicates removed.
For the numbers columns I need the numbers added up from the removed columns.
Here is an example of what I have:
What I want it to look like is this:
So it will remove those other duplicates and then add the numbers to the remaining column.
I also want this file to not care about Caps....So
automotive should be considered the same.
Michael R Roberts