Find Jobs
Hire Freelancers

Google Sheets- Formula creation, macro writing.

$30-250 AUD

Fullført
Lagt ut nesten 4 år siden

$30-250 AUD

Betalt ved levering
Task 1, Formula creation. Cell C8-C11 can manually input data of values of R1, R2 up to R12 in any combination, cells also can be empty. example C8-C10 can have values and C11 does not. Cell E14 will display the answer we are looking for. Condition of formula, We are looking for the missing number in between. If R1 and R3 are present R2 is missing and will be displayed in E14 If R12 and R2 is present R1 is missing and will be displayed in E14 If R1, R3, R5, R7 is in Cells C8-C11, The Missing numbers will be R2,R4,R6 to be displayed in Cell E14. Note: Numbers connected in a sequence, R1,R2,R3,R4,R5,R6,R7,R8,R9,R10,R11,R12,R1,R2 and so on. An ideal solution will be a one-line formula that if a reference table with fixed values is required, another sheet can be used and referenced to. If the formula requires a table with variable values, Cells V1-AA5 can be used. Task2, Macro writing. Teach me to and assist me to create a macro that when run. when mouse is selected A value is a name creates a new spreadsheet with that name, then goes back to the same sheet then copys the B value and pastes it in a specific cell then goes back to the original sheet and copys C value and then pastes it into the new sheet within a specific cell and so on.
Prosjekt-ID: 25800684

Om prosjektet

7 forslag
Eksternt prosjekt
Aktiv 4 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
Hi, I have read your project details. I think I will be able to complete your assigned task because I have the following task experiences i.e. Result processing using Excel Formula. I am committed to complete my task within budget time. Most importantly, Now, I am living in Australia, available online more than 12 hours and I don't have any other jobs. Therefore I would like to discuss with you about the job details. Thanks in advance.
$30 AUD om 1 dag
5,0 (10 omtaler)
3,5
3,5
7 freelancers are bidding on average $83 AUD for this job
Brukeravatar
Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within 2 days
$180 AUD om 2 dager
4,9 (58 omtaler)
5,4
5,4
Brukeravatar
Hi, I am VBA Developer. Expert in VBA Macros & Web Scrapping. I’ve seen your vba task requirements. I can complete this task in a day only. Please Reply with the details. Looking forward to your response. Thanks
$52 AUD om 1 dag
4,9 (45 omtaler)
4,8
4,8
Brukeravatar
Hello! I read your description and understand it fully. If I understand clearly you just need a macro and a formula built in for Google sheets right? if that's the ask without other intricacies I can do the job for you for sure. I have a 4 years of working as a financial analyst for JPMorgan, and hence have a lot of experience with excel/sheets and automation Please message me in chat so we can discuss further.
$56 AUD om 1 dag
5,0 (6 omtaler)
2,6
2,6
Brukeravatar
I am good and onest in my work Relevant Skills and Experience I am skill and relavent in this project in uae also
$111 AUD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I can do it I have 5+ years experienced on excel .... hope we start work ... for both more query we talk to chat...
$100 AUD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I have a professional degree in computer engineering. I have a 1 year experience in SIGMA ELECTRICAL and 2 year experience in shree enterprises where i was employed as a software technician.
$50 AUD om 7 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

AUSTRALIAs flagg
Homebush West, Australia
5,0
1
Betalingsmetode bekreftet
Medlem siden mai 31, 2020

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.