Write a google spreadsheet formula (combine two lists)

Dibatalkan Disiarkan 6 tahun lepas Dibayar semasa penghantaran
Dibatalkan Dibayar semasa penghantaran

I am looking for someone who can write a google spreadsheet formula.

This is what the formula needs to do:

I have 2 lists that need to be combined.

A list has 2 columns, one column for the word and one column for a number.

_______________________________________________________________________

Example List 1:

macbook 5

repair 3

screen 3

test 3

book 2

_______________________________________________________________________

Example List 2:

macbook 5

fly 3

screen 3

go 3

books 1

_______________________________________________________________________

The result will be:

macbook 10

repair 3

screen 6

test 3

book 2

fly 3

go 3

books 1

_______________________________________________________________________

The second list gets merged with the first list and the number gets added.

This is just an example. The lists I need to combine will be always different so the formula needs to be dynamic.

I have attached a screenshot of the example so you can see how it looks like.

Please review everything and end your job application with the word 'letsstart' so I know you have read the job description.

Pemasukan Data Pemprosesan Data Excel Matematik

ID Projek: #15436541

Tentang projek

33 cadangan Projek jarak jauh Aktif 6 tahun lepas

33 pekerja bebas membida secara purata $19 untuk pekerjaan ini

P0L

Hey, I'm interested in your project. Please send me a message so that we can discuss more. Stay tuned, I'm still working on this proposal.

$15 USD dalam sehari
(280 Ulasan)
7.2
HardWorker1989

Hi there. I can help you out in getting the formula to merge two lists and sum it up as you have requested in the job description. Thanks & 'letsstart' Relevant Skills and Experience 10+ years experience in MS Excel Lagi

$15 USD dalam 0 hari
(102 Ulasan)
7.0
elqueabandona

letsstart Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y ex Lagi

$15 USD dalam 0 hari
(210 Ulasan)
6.8
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start Stay tuned, I'm still working Lagi

$15 USD dalam 0 hari
(109 Ulasan)
5.5
robin1108

I understood the task and setup the formula in the sheet now. So, 'letsstart' now. Relevant Skills and Experience I have huge relevant skills and able to complete the task within 10 mins. Proposed Milestones $15 USD Lagi

$15 USD dalam 10 hari
(57 Ulasan)
5.3
mohamedkaram93

Hi! I will be happy to help you with that. We will have a script actually not formula. You will highlight the range of the two lists and the script will populate the result in the next 2 columns

$30 USD dalam 0 hari
(17 Ulasan)
4.9
cyash61

letsstart I am an analytics consultant with more than 6 years of experience working with excel for 2 majro consulting firms. Can take up this job smoothly. Relevant Skills and Experience More than 70 projects on excel Lagi

$30 USD dalam sehari
(7 Ulasan)
4.3
eskemar

Dear I have good computer skill and I have been through Ms Office, PDF, Data entry, Typing and copy/paste for many years. I have a question on the project; in how many days or hrs do you need your work to be done? For Lagi

$15 USD dalam sehari
(15 Ulasan)
3.9
mikhailkozalski

I am a Great Mathematician. I can sure about my price and the deadline. My way of working is not only to complete but also to provide enough understanding to the project owner. So this will be base of our long term Lagi

$20 USD dalam sehari
(7 Ulasan)
3.6
Junaid221

hi dear! i have seen your project description i can do it perfectly if you give me this work. thanks Relevant Skills and Experience data entry , excel Stay tuned, I'm still working on this proposal.

$20 USD dalam 10 hari
(10 Ulasan)
3.6
fadhgal

I am ready to Start Working Now i have enough experience to deal with the project and i will do a professional work just give me the chance to show what i can do Relevant Skills and Experience excel

$15 USD dalam 3 hari
(6 Ulasan)
2.2
Inno4Future

Hi, Please provide me the access token which have permission to access the google spread sheet. regards, Relevant Skills and Experience node.js, python, java Proposed Milestones $15 USD - Completed

$15 USD dalam 0 hari
(2 Ulasan)
2.0
HasnaHaris

Hi, i just checked your description and would be pleasure to assist you in your project. looking forward to discuss further details in the chat. Stay tuned, I'm still working on this proposal.

$15 USD dalam sehari
(3 Ulasan)
1.6
irfan13me

Hi sir! I have gone through your project description and I’m very much interested in doing your project. I can deliver on time according to your specifications. I’m sure I will exceed your expectations. Thanks

$15 USD dalam sehari
(2 Ulasan)
1.5
rokunzzaman99

Dear Hiring Manager, I have gone through your job-posting and become very eager to work with you.I have a group of young energetic team. Best in Business Rokunzzaman Stay tuned, I'm still working on this proposal.

$15 USD dalam sehari
(3 Ulasan)
0.4
sadiqrahim123

I am excellent in writing formulas in excel/spreadsheet cells to perform different functions, like, summation, multiplication, division, bracket, lookup data, complex formulas for combining databases. Relevant Skills Lagi

$20 USD dalam 10 hari
(0 Ulasan)
0.0
phmasc

É possível realizar com máxima eficiência e mínimo de tempo!

$15 USD dalam sehari
(0 Ulasan)
0.0
sumanahmedbd

I complete this project carefully. Please give me this project.

$20 USD dalam 10 hari
(0 Ulasan)
0.0
jasmeet88mae

A proposal has not yet been provided

$15 USD dalam 2 hari
(0 Ulasan)
0.0
tauqeerakram

I will perform this task for 15$ in 5 Days. Relevant Skills and Experience I am working on excel since last five years. Proposed Milestones $15 USD - USD 5

$15 USD dalam 5 hari
(0 Ulasan)
0.0