Remove duplicates add the numbers (Excel file)

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:

Automotive 2

Automotive 4

automotive 1

What I want it to look like is this:

Automotive 7

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 and

automotive should be considered the same.


Michael R Roberts

Beceriler: C++ Programlama, Veri Girişi, Veri Madenciliği, Excel

Daha fazlasını görün: n numbers, remove duplicates numbers, Remove, remove from, excel 7, duplicates excel, excel file columns, excel numbers, columns excel, look duplicates excel, excel data automotive, excel data columns, column data excel, column excel, excel column column, excel column data column, remove duplicates, excel 2010 add, numbers data entry, data entry excel file, entry excel file, excel 2010, automotive data entry, numbers entry, data entry numbers

İşveren Hakkında:
( 174 değerlendirme ) Bend, United States

Proje NO: #752673



Hi, Please view PM. Thank you

1 gün içinde 33$ USD
(2 Değerlendirme)

4 freelancers are bidding on average $66 for this job


Ready to work perfectly as per your requirement.

1 gün içinde 100$ USD
(125 Değerlendirme)

Greetings Oregon from Pennsylvania.. {smile} 25+ year MsExcel expert.. I can have you all grouped and totalled up very little time. Please see PMB. Respectfully, Bill.

1 gün içinde 32$ USD
(11 Değerlendirme)

ready to to start right now...

in 0 gün içinde100$ USD
(23 Değerlendirme)

Hi, This is a fairly simple task, I can do this for you immediately. Thanks

1 gün içinde 100$ USD
(0 Değerlendirme)