Find Jobs
Hire Freelancers

Google Sheets Formula Help

£10-20 GBP

Dokončeno
Zveřejněno před více než 5 roky

£10-20 GBP

Zaplaceno při doručení
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
IČ projektu: 18643993

O projektu

18 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
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 v 1 dni
5,0 (9 recenze)
4,3
4,3
18 freelanceři nabízejí v průměru £17 GBP za tuto práci
Avatar uživatele
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 v 0 dni
4,9 (348 recenze)
7,2
7,2
Avatar uživatele
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 v 1 dni
5,0 (24 recenze)
7,2
7,2
Avatar uživatele
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 v 1 dni
5,0 (218 recenze)
7,0
7,0
Avatar uživatele
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 v 1 dni
4,8 (85 recenze)
6,0
6,0
Avatar uživatele
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 v 1 dni
5,0 (40 recenze)
5,4
5,4
Avatar uživatele
Pleasure to help you. I can do google spreadsheet. Feel free to message me to start the job. Thank you so much.
£20 GBP v 1 dni
4,9 (75 recenze)
5,7
5,7
Avatar uživatele
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 v 3 dnech
5,0 (5 recenze)
4,0
4,0
Avatar uživatele
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 v 1 dni
5,0 (5 recenze)
3,6
3,6
Avatar uživatele
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 v 1 dni
5,0 (1 recenze)
1,4
1,4
Avatar uživatele
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 v 1 dni
0,0 (1 recenze)
0,0
0,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I have work experience on excel &it's various formulas. Can do this in moments and send back.. Thank you
£13 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I am interested in this project Thank you
£18 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I am a student in mathematics and computer science .
£20 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UNITED KINGDOM
Grantham, United Kingdom
5,0
42
Ověřená platební metoda
Členem od lis 25, 2010

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.