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.
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
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
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.
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.