Find Jobs
Hire Freelancers

Complicated Excel Formula Modification Assistance

$15-25 USD / hour

Finalizat
Data postării: aproape 4 ani în urmă

$15-25 USD / hour

I need someone to help me modify formulas, over the next 2 hours. I am working on a project too complicated to explain. It is an excel WB I have been building over the last 7 years. I am making major modifications to it These formulas previously worked but need to be modified to function in the new format. I am looking for someone to work hand in hand with me. An example of what will be required is as followed. I have the formula =@IF(F$11="","",IF($C$29="Half End",@INDEX(INDIRECT(F$11&"!"&Constants!$B$7),$N$14,MATCH($N$15,INDIRECT(F$11&"!"&Constants!$C$7),0))*0.5,IF($C$29="Open","",IF($C$29="Gable Only",INDEX(INDIRECT(F$11&"!"&Constants!$B$21),$N$14),INDEX(INDIRECT(F$11&"!"&Constants!$B$7),$N$14,MATCH($N$15,INDIRECT(F$11&"!"&Constants!$C$7),0)))))) I want to nest inside it, F($C$29="Extended Gable",INDEX(INDIRECT(F$11&"!"&Constants!$B$21),$N$14),INDEX(INDIRECT(F$11&"!"&Constants!$B$7),$N$14,MATCH($N$15,INDIRECT(F$11&"!"&Constants!$C$7),0 I will promise $50USD for the next 2 hours, with a possible tip of an additional $50 if you are very fast on your solutions. This very could lead to a big job of reconstructing this WB into a DB. Chat with me for details
ID-ul proiectului: 25521648

Despre proiect

10 propuneri
Proiect la distanță
Activ: 4 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
HI, I am good at Excel formulas. I can crack in 2 hours. Looking forward to work on the project. Please share the Excel file to look into the data and apply the formula as required. -Chandra
$25 USD în 2 zile
5,0 (990 recenzii)
8,1
8,1
10 freelanceri plasează o ofertă medie de $23 USD/oră pentru proiect
Avatarul utilizatorului
Hello, I am an Excel expert and I would like to help you with your formulas. Please check my profile and contact me to discuss further details. Regards.
$25 USD în 10 zile
4,9 (460 recenzii)
7,9
7,9
Avatarul utilizatorului
Hello Just a suggestion from my end. Instead of writing complex formula, you can write down custom functions in VBA and use that from the excel cells. I am good at writing excel functions and macros. Please ping me to discuss further. Thanks Gokul
$20 USD în 3 zile
5,0 (117 recenzii)
6,1
6,1
Avatarul utilizatorului
Hi there, You have a formula that dynamically refers to a particular sheet based on the criterion/ value on a cell. Probably you added more sheets in your workbook thus you need to expand the formula. Please message me. I’ll be standing by to add the new formula in you WB. -Reggie
$40 USD în 2 zile
5,0 (30 recenzii)
5,1
5,1
Avatarul utilizatorului
Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Office -Python -PowerPointMacros -Automatioin -Automation tools -PowerBI -VBA -Excel and VBA automation - etc. A professional having more than 7 years of experience in financial modeling, VBA macros, MS Office automation with postgraduate degree, Worked in reputed organisations on senior level. I am expert in my field, who knows the value of time, very hard working and always delivers the work on time. I always deliver the work well in advance with continues communication & timely response until satisfactory completion of the project. I only accept the projects which I am sure can be done within the stipulated time frame and budget.. I always deliver 100% Satisfaction to the client. Hope my skill and work can help you with your business. i look forward to have further discussion with you in the chat. Thanks Regards ATEMENU.D
$20 USD în 40 zile
4,9 (10 recenzii)
4,2
4,2
Avatarul utilizatorului
I'm experienced Excel Expert with 06 yrs of experience in the field. I have done multiple successful projects like this. I can help.
$31 USD în 40 zile
5,0 (8 recenzii)
3,8
3,8
Avatarul utilizatorului
Hey, I read the project details and understand that, I am an expert in excel due to my previous work and can help you with this. One thing can you just share sample data and output in message box to implement the formula exactly as you want. Looking forward.
$20 USD în 1 zi
4,7 (4 recenzii)
2,5
2,5
Avatarul utilizatorului
I'm professional data entry operator available for long term. I have used excel, word and other tools.
$15 USD în 40 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Hello, Working as a financial analyst, I have great experience with excel templates and reports, automation with VBA/Macros. Especially, I have deep experience with vlookup, indirect, index and match and other advanced function. Furthermore, I am detail-oriented and always finish my jobs within timeline. With these, I believe I will be a good candidate for this job. Please consider my proposal and leave me a message. Thank you.
$16 USD în 50 zile
5,0 (1 recenzie)
0,0
0,0
Avatarul utilizatorului
Before we give brief of our profile, we would like to share that we are very keen to do your assignment and are even willing to do the first assignment at your cost to establish a relationship and demonstrate our capabilities. Professionally I am a certified accountant from India since 1992 and have experience of working and managing books of accounts from a small scale organization to the large organizations with an expert knowledge of accounting, commercial and legal aspects besides having good communication skills. I have an experience of 28 years in this field with the reputed organizations. We can do assignments from basic accounting to budgeting, MIS reports, commercial negotiations and Balance Sheet Finalizations. I have hands-on experience in doing the accounting jobs and have done basic works like voucher preparation , data entry in the software , making the Trial Balance and preparing the Balance sheets both manually in earlier days and thru the Software in the current scenario. I have the ability to analyze the Trial Balance and subsequently the Balance sheets. We do detailed analysis of all the TB accounts like sundry creditors etc and provide you with an invoice wise outstanding. We have expertise in doing all sort of reconciliations We prepare schedules for all the major accounts for the management understanding. We also share two page report of the accounts with clear actions required at your end and do follow up till it is closed.
$15 USD în 40 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul UNITED STATES
Virginia Beach, United States
5,0
46
Metoda de plată a fost confirmată
Membru din feb. 27, 2014

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.