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 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:
( 187 değerlendirme ) Bend, United States

Proje NO: #752673



Hi, Please view PM. Thank you

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(2 Değerlendirme)

Bu iş için 3 freelancer ortalamada $78 teklif veriyor


Ready to work perfectly as per your requirement.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(305 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)