Find Jobs
Hire Freelancers

Excel Advanced Formula to return cell below in a lookup and continue looping until completed

$30-250 USD

Completed
Posted over 4 years ago

$30-250 USD

Paid on delivery
I have an excel sheet that captures resource utililzation we have 2 rows (merged) in columns A showing resource name the table in the screenshot below shows utilization within a 1 week period I need a formula that has a project name as the input value, and the search should be the % underneath that cell - the end result should show 1) a count of resources on that project 2) the total percentage allocation i.e. SUM of %s i need this ASAP bUJET IS 100 dollars
Project ID: 21813631

About the project

40 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 Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ([login to view URL]). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this as I may have some questions. Best Regards, Jay
$100 USD in 1 day
5.0 (781 reviews)
8.6
8.6
40 freelancers are bidding on average $95 USD for this job
User Avatar
Dear Employer, I have checked your Screenshot and understand the formula and based functionality that you need. Please message me to discuss further, I am an expert with over 12 years of experience and will do a perfect job asap. I know I am charging a bit more than others but you will not regret paying me that looking at my work I promise. Please do check my previous reviews once for your kind consideration!! :) Thanks and Regards, Ash
$100 USD in 1 day
5.0 (201 reviews)
7.8
7.8
User Avatar
Hi, I am good in your required project, I also have a great working experience of more than 10 years. To ensure please visit my profile and check customers satisfaction level. I will complete your project within your given deadline. Thank you.
$100 USD in 1 day
4.9 (290 reviews)
7.5
7.5
User Avatar
Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$175 USD in 3 days
4.9 (144 reviews)
7.4
7.4
User Avatar
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad
$30 USD in 1 day
5.0 (223 reviews)
7.1
7.1
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
$100 USD in 1 day
4.9 (424 reviews)
7.1
7.1
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$100 USD in 1 day
5.0 (275 reviews)
7.1
7.1
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. can fulfill your request either using formula or using a vba macro. Thank you, Regards.
$100 USD in 1 day
5.0 (129 reviews)
6.5
6.5
User Avatar
Hi, I am an expert in Excel with 8 years of experience. I have checked the attached image I can complete your project tonight. Please send me the data I am ready to start your project. Thanks
$100 USD in 1 day
4.9 (91 reviews)
6.1
6.1
User Avatar
Hello, I can write an Excel formula for calculations resources and allocation according to your requirements (with helper sheet). Let’s discuss if you’re interested. Best regards, Duong
$100 USD in 1 day
4.9 (43 reviews)
6.3
6.3
User Avatar
$30.00 Only ------ In just 12 Hours ------- Excel Data Management, VBA Macro Coding and Formula Generation Expert
$30 USD in 1 day
5.0 (122 reviews)
5.5
5.5
User Avatar
Hello, I am a Chartered Accountant and an excel expert. I can provide the required formula that will be based on lookups and simple additions and summations without any complicated codes. Please do message me if you are interested in my offer. Kind regards, Anjul
$100 USD in 1 day
5.0 (31 reviews)
5.3
5.3
User Avatar
Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards
$98 USD in 2 days
4.6 (54 reviews)
5.8
5.8
User Avatar
Hello sir I am very interesting to work on your project I am expert in excel and can provide you very professional service and help anytime and I read your project carefully and create initial image for what you need but need to contact with you for start and more details Thanks and appreciate if you take quick view on my profile
$95 USD in 7 days
5.0 (23 reviews)
4.9
4.9
User Avatar
Hi Good Day! A serious freelancer here. I can help you to complete this project. I can make it automated using Excel Formulas and VBA Macro. Mesage me anytime to discuss more about this project. Please consider my bid, I really need this work. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$100 USD in 2 days
4.9 (48 reviews)
4.8
4.8
User Avatar
Hello I am highly interested to work with you on this project and can assure you quality results. Thank you
$100 USD in 1 day
5.0 (12 reviews)
4.3
4.3
User Avatar
READY! Hi Sir, I’m a professional accountant in KSA, who have 6+ years of experience. With high MS excel and financial management knowledge. I can provide you free samples with high quality and in a fair price. Please, feel free to contact me. Thanks
$30 USD in 1 day
5.0 (15 reviews)
4.2
4.2
User Avatar
Hi there, Expert here, Sir i have read your project and it's match with my skills i can provide you quality work on time Can you please come to the chat box so we can easily discuss about project details.. Thank You Regards Muhammad Jibran
$150 USD in 1 day
5.0 (3 reviews)
3.8
3.8
User Avatar
Hi, sir. Thank you for your posting.:) I am very interesting in your project and I have checked your file. I am excel and excel vba expert. I have rich experience of making excel project using vba. For example I have made finance excel project. I have been working as a excel expert for 7 years. If you want me, please ping me. I will do my best for you. Best regards.:)
$100 USD in 1 day
5.0 (9 reviews)
3.9
3.9
User Avatar
Hi , I am an MBA professional having 4yrs of experience in Analytics, Tableau, Advanced Excel, VBA and Python. I have done ample amount of work in excel and VBA and I could show some examples of it. I have read the description of the project mentioned above but I am still not clear about it. I would like to have to chat with you to understand more about and help you in accomplishing the goal. Looking forward to work with you.
$40 USD in 1 day
5.0 (9 reviews)
3.5
3.5
User Avatar
it`s an easy project and can be finished in less than the determined time. I`m interested in your project pleas contact me to discuss the other details thank you
$80 USD in 1 day
4.5 (11 reviews)
3.2
3.2

About the client

Flag of SAUDI ARABIA
Riyadh, Saudi Arabia
5.0
3
Payment method verified
Member since Jul 14, 2017

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.