Devam Ediyor

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.

Thanks!

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 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, 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, numbers excel, need numbers, automotive words

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

Proje NO: #752673

Seçilen:

WebSolution4

Hi, Please view PM. Thank you

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

4 freelancer bu iş için ortalamada 66$ teklif veriyor

FINGERRPRINT

Ready to work perfectly as per your requirement.

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

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)
4.8
sehgals

ready to to start right now...

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

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)
0.0