Đã hoàn thành

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

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

Kĩ năng: Excel, Visual Basic, Xử lí dữ liệu

Xem nhiều hơn: excel vba function return blank cell, excel max drawdown return formula, excel macro concatenate formula number cell, excel carriage return cell, excel internal rate return formula, formula return instance excel, excel vba refresh formula in cell, excel macro add formula to cell, excel macro insert formula into cell, excel find text in range and return cell reference, excel conditional formatting formula if cell contains text, excel index match return multiple values in one cell, excel formula color cell if value, excel formula if cell contains text then return value in another cell, excel hyperlink formula to cell, excel return cell address instead of value, excel copy row if cell contains certain text formula, excel vba insert formula in cell, excel vba formula in cell with variable, excel formula repeat cell value

Về Bên Thuê:
( 1 Nhận xét ) Riyadh, Saudi Arabia

ID dự án: #21813631

Được trao cho:

jaylancer43

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 (g Thêm

$100 USD trong 1 ngày
(729 Đánh Giá)
8.5

46 freelancer đang chào giá trung bình $96 cho công việc này

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Thêm

$100 USD trong 2 ngày
(333 Nhận xét)
7.9
asin1987

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 per Thêm

$100 USD trong 1 ngày
(183 Nhận xét)
7.6
TonmoyRoy111

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 trong 1 ngày
(333 Nhận xét)
6.8
elqueabandona

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 proje Thêm

$100 USD trong 1 ngày
(233 Nhận xét)
6.9
zekovicm

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 Thêm

$175 USD trong 3 ngày
(120 Nhận xét)
7.3
datakillers

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 g Thêm

$100 USD trong 1 ngày
(181 Nhận xét)
6.7
polarjin2017

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] Thêm

$155 USD trong 3 ngày
(95 Nhận xét)
6.7
asadkhan3533

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 trong 1 ngày
(149 Nhận xét)
6.5
hdlan

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 trong 1 ngày
(38 Nhận xét)
6.2
periyannas

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 Thêm

$100 USD trong 1 ngày
(109 Nhận xét)
6.3
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Thêm

$100 USD trong 1 ngày
(121 Nhận xét)
5.9
aimefx

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 trong 1 ngày
(77 Nhận xét)
5.9
sonarkaushik

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 trong 2 ngày
(54 Nhận xét)
5.8
nwss1986

Hi, I went through the attached screenshot. I assume, DCT,MGMT are the project names and JJ INC II, JJ INC SS are the resource names and its corresponding utilization in percentage. I understood your requirement. I sug Thêm

$67 USD trong 1 ngày
(90 Nhận xét)
5.6
AhmedMarzoq

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 Thêm

$95 USD trong 7 ngày
(22 Nhận xét)
4.9
paulodayto08

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 bi Thêm

$100 USD trong 2 ngày
(35 Nhận xét)
4.4
Anjulagrawal26

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 a Thêm

$100 USD trong 1 ngày
(17 Nhận xét)
4.3
TopDesigner315

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 m Thêm

$100 USD trong 1 ngày
(9 Nhận xét)
3.9
AnowarRatul

$30.00 Only ------ In just 12 Hours ------- Excel Data Management, VBA Macro Coding and Formula Generation Expert

$30 USD trong 1 ngày
(33 Nhận xét)
4.0
hkh581e5c8f1cb8a

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, Thêm

$30 USD trong 1 ngày
(11 Nhận xét)
3.6