Write a google spreadsheet formula (combine two lists)

Zrušen Zveřejněno před 6 lety K zaplacení v momentě doručení
Zrušen K zaplacení v momentě doručení

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.

Zadávání dat Zpracování dat Excel Matematika

Identifikační číslo projektu: #15436541

O projektu

33 nabídek Projekt na dálku Aktivní před 6 lety

33 Freelnceři na tento projekt zveřejňují nabídky v průměru $19

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 za 1 den
(280 Recenzí)
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 Další

$15 USD za 0 dní
(102 Recenzí)
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 Další

$15 USD za 0 dní
(210 Recenzí)
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 Další

$15 USD za 0 dní
(109 Recenzí)
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 Další

$15 USD za 10 dní
(57 Recenzí)
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 za 0 dní
(17 Recenzí)
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 Další

$30 USD za 1 den
(7 Recenzí)
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 Další

$15 USD za 1 den
(15 Recenzí)
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 Další

$20 USD za 1 den
(7 Recenzí)
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 za 10 dní
(10 Recenzí)
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 za 3 dní
(6 Recenzí)
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 za 0 dní
(2 Recenzí)
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 za 1 den
(3 Recenzí)
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 za 1 den
(2 Recenzí)
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 za 1 den
(3 Recenzí)
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 Další

$20 USD za 10 dní
(0 Recenzí)
0.0
phmasc

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

$15 USD za 1 den
(0 Recenzí)
0.0
sumanahmedbd

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

$20 USD za 10 dní
(0 Recenzí)
0.0
jasmeet88mae

A proposal has not yet been provided

$15 USD za 2 dní
(0 Recenzí)
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 za 5 dní
(0 Recenzí)
0.0