Find Jobs
Hire Freelancers

Google Sheets Formula Help

£10-20 GBP

Đã hoàn thành
Đã đăng vào hơn 5 năm trước

£10-20 GBP

Thanh toán khi bàn giao
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
Mã dự án: 18643993

Về dự án

18 đề xuất
Dự án từ xa
Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
Đã trao cho:
Avatar người dùng
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 trong 1 ngày
5,0 (9 nhận xét)
4,3
4,3
18 freelancer chào giá trung bình £17 GBP cho công việc này
Avatar người dùng
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 trong 0 ngày
4,9 (348 nhận xét)
7,2
7,2
Avatar người dùng
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 trong 1 ngày
5,0 (24 nhận xét)
7,2
7,2
Avatar người dùng
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 trong 1 ngày
5,0 (218 nhận xét)
7,0
7,0
Avatar người dùng
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 trong 1 ngày
4,8 (85 nhận xét)
6,0
6,0
Avatar người dùng
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 trong 1 ngày
5,0 (40 nhận xét)
5,4
5,4
Avatar người dùng
Pleasure to help you. I can do google spreadsheet. Feel free to message me to start the job. Thank you so much.
£20 GBP trong 1 ngày
4,9 (75 nhận xét)
5,7
5,7
Avatar người dùng
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 trong 3 ngày
5,0 (5 nhận xét)
4,0
4,0
Avatar người dùng
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 trong 1 ngày
5,0 (5 nhận xét)
3,6
3,6
Avatar người dùng
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 trong 1 ngày
5,0 (1 nhận xét)
1,4
1,4
Avatar người dùng
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 trong 1 ngày
0,0 (1 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I have work experience on excel &it's various formulas. Can do this in moments and send back.. Thank you
£13 GBP trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I am interested in this project Thank you
£18 GBP trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I am a student in mathematics and computer science .
£20 GBP trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của UNITED KINGDOM
Grantham, United Kingdom
5,0
42
Phương thức thanh toán đã xác thực
Thành viên từ thg 11 25, 2010

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.