Find Jobs
Hire Freelancers

Google Sheets Formula Help

£10-20 GBP

Completed
Posted about 5 years ago

£10-20 GBP

Paid on delivery
I have a Google Sheets file that I need a formula for. Please see the attached images. I need a formula that will copy the data on the sheet labelled "All Ongoing Cases" and put it on the correct sheet depending on the value in Column "I" For example you can see that the data in Rows 3&6 has been copied to the "DIP ACCEPT" sheet because in Column I on the "All Ongoing Cases" sheet the data is "DIP ACCEPT". Please only bid if you know how to do this. Any questions please ask. This is a very simple task for the right person so please make sure your bids reflect this. T
Project ID: 18643993

About the project

18 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello I would be able to help you. This is quite simple fix once you’ve seen it once and can be used in multiple situations. Please let me know if you would like me to explain and I will do so ASAP. Kind regards Steve
£20 GBP in 1 day
5.0 (9 reviews)
4.3
4.3
18 freelancers are bidding on average £17 GBP for this job
User Avatar
Hi there, I have read your project description you want "Google Sheets Formula Help". I can definitely help you with your project. Once knock me so we can discuss more. Thanks!
£20 GBP in 0 day
4.9 (348 reviews)
7.2
7.2
User Avatar
Hi, I went through your description and images. You need to copy entire row if the "I" column has "DIP ACCEPT" and this should be done through a formula. I will you give you a of formulas and you need to paste them A2 to I2 in "DIP ACCEPT" sheet. Then select these formulas and draw them down. The down rows will show the data is column "I" is equal to "DIP ACCEPT" and if not, the rows will be empty even though they are filled with formulas.
£10 GBP in 1 day
5.0 (24 reviews)
7.2
7.2
User Avatar
Greetings! The best option for your requirement would be the use of macros. I can develop the macros that would automatically copy data to the appropriate sheets from the main "All Ongoing Cases" sheet. Have a Great Weekend! Srinivasan
£15 GBP in 1 day
5.0 (218 reviews)
7.0
7.0
User Avatar
I have excellent command on Google Sheets and know the formula to copy over data into respective fields based on the selected values. I have completed complex projects before. For instance - Get live cyptocurrency data and create dashboard using coinmarket API - Upload and Manage Videos in Vimeo using JSON API in google sheets - Extract mails and attachments from gmail to google sheet and drive respectively - Twitter functionality like retweet, auto-tweet, and so on - Integrated Google Sheets, Forms and docs to create a dashboard and tracking system to track health data of individuals for a health care organization You can see the reviews of the same in my profile
£20 GBP in 1 day
4.8 (85 reviews)
6.0
6.0
User Avatar
Have the formula in your Google Sheet customized while YOU FOCUS ON OTHER IMPORTANT MATTERS. RELAXED! Entrust this to a professional that gives your interests utmost importance. Hi, my name is Reggie, during my decade-long back office experience in full-time setting, I had been in situations that I had to delegate some urgent tasks to others because of more important matters at hand, only to find out at end, that the job I delegated was neither accomplished, turnaround on time nor as specified. FRUSTRATING! Isn’t it? You may see some of my work here: https://www.freelancer.com/u/IgeS That experience has motivated me to have expertise in my craft so I can deliver to others what some couldn’t provide to me – ON TIME AND 99.99% ACCURATE TURNAROUND. My service, not only SAVES YOU MONEY because of its competitive rate but also SAVES YOU TIME dealing with back jobs (if there’s any). “nice guy to work with” - alexlexa “Regginald did a superb job… He did the job quickly and it looked great. I'd use him again.” - hdwillis “verygoodlogo” - hassnalajmi LET’S WORK together NOW
£10 GBP in 1 day
5.0 (40 reviews)
5.4
5.4
User Avatar
Pleasure to help you. I can do google spreadsheet. Feel free to message me to start the job. Thank you so much.
£20 GBP in 1 day
4.9 (75 reviews)
5.7
5.7
User Avatar
Hi, I hope my experience with Programming and Advanced Excel skills will help you consider my application. Let me know if you have questions Thanks Roel
£23 GBP in 3 days
5.0 (5 reviews)
4.0
4.0
User Avatar
Hi, This sounds like an extremely easy task for me. I have done similar tasks many times. My bid is low just because I don't have any experience on this platform, but I have vast professional experience as a Data Analyst using mainly Excel to automate reports. To do your task, I'll need to add 1 or 2 supporting column(s) on sheet 'All Ongoing Cases". Then I'll replicate formulas on the other sheets. In this way every time you add a new row on sheet 'All Ongoing Cases' or modify any of the existing information, data will be automatically added or updated on the respective sheet, depending on stage.
£10 GBP in 1 day
5.0 (5 reviews)
3.6
3.6
User Avatar
Hi, I can perfectly do the project. I have been working on such projects. I deliver quality, commitment and make sure there is no Plagiarism. I am familiar with all sorts of reference styles. Please send me a message! and let's start working
£18 GBP in 1 day
5.0 (1 review)
1.4
1.4
User Avatar
Dear, I majored in mechanics and have the qualification of Master of Mechanics. And I am a talented Google Sheets expert. I have 10 years of experience and a good history in Google Sheets. I can do your task well and accurately. I will wait for your good reply. Thanks.
£18 GBP in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
I understand your project, it is a simple one please give me an opportunity to work for you. I will complete your work in 1 day.
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have work experience on excel &it's various formulas. Can do this in moments and send back.. Thank you
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am interested in this project Thank you
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will also teach you the right way to do this by yourself. Hi, I'm Oussama from morocco i'm an expert of excel and data entry, i can do this job for your with the correct way and I will also teach you the method so you can do this by yourself . best regards
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a student in mathematics and computer science .
£20 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
On a1 of the app sheet write: ={query(‘All ongoing cases’!A1:Z;”select A,B,C,D,E,F,G,H,I,J where I = ‘Dip accept’ “;1} Choose me
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Grantham, United Kingdom
5.0
42
Payment method verified
Member since Nov 25, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.