Find Jobs
Hire Freelancers

Excel Programming

min €36 EUR / hour

Closed
Posted 11 months ago

min €36 EUR / hour

I would like you to create a complex excel formula. It is a function that has 3 input parameters and 4 possible output parameters. The input data are found in the link below. The 3 input are the first 3 columns (A, B, C). The formula should yield the results in the column D. [login to view URL] IMPORTANT: You must not use any makros or visual basic. Also, just creating a simple IF function for each linke of the table wont work, because excel limits the total number of these function to 64 I believe. In this case there would be slightly more than that. So you will have to cluster these results to make the formula shorter. I have created an example how such formula / your result could look like. This example is in column E. It is very time sensitive. If you can finish TODAY, great, latest TOMORROW. Thanks : )
Project ID: 36701720

About the project

71 proposals
Remote project
Active 9 mos 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
71 freelancers are bidding on average €42 EUR/hour for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
€36 EUR in 40 days
4.9 (556 reviews)
8.5
8.5
User Avatar
Hello, I am a Google Sheets expert and I can help you with your formulas. Please send me a message so that we can discuss more.
€40 EUR in 1 day
5.0 (503 reviews)
8.1
8.1
User Avatar
"""""""""""""""""""""""""""""""""""""""ADVANCE EXCEL EXPERT"""""""""""""""""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 300+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
€36 EUR in 40 days
4.9 (266 reviews)
7.3
7.3
User Avatar
Hello, I am an Excel formulas expert. I have visited the link to check 3 input parameters and 4 possible output parameters. I offer my services to create the complex formula (no VBA/macro) that takes the input and provide the correct output. I'll complete this within your deadline and within minimum time and cost. I have completed many complex Excel formula projects with 5 star ratings and excellent reviews. You can check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid
€36 EUR in 40 days
5.0 (105 reviews)
6.2
6.2
User Avatar
Hi, I am Sajib, I can help you on this project to create a formula. I am expert in excel formula. Please check my profile for more details. Thanks
€36 EUR in 4 days
5.0 (80 reviews)
5.8
5.8
User Avatar
Greetings, I am an Advanced Level Excel Formula expert and an Accountant. I am very confident to start your project and complete it with all efficiency you are looking for. I understand the requirements and am able to start this project right now. Let’s get started by initiating a chat box to make your project to the next level of automation.
€36 EUR in 40 days
5.0 (85 reviews)
5.5
5.5
User Avatar
I understand you are looking for someone to create a complex excel formula that has 3 input parameters and 4 possible output parameters. If you can let me know when you are looking for help today, I can show you an example of how such a formula/your result could look like in column E. My name is MD JAMRUL and I am a Data Entry, WordPress, Shopify, and eCommerce expert. With over 10 years of experience in data processing and excel programming, I am confident that I can deliver the results you are looking for. I have the skills necessary to complete this project: Data Processing, Excel. Specifically with regard to this project, I am experienced in entering data into spreadsheets, databases, and other systems so that information is organized and easy to access; optimizing websites for search engines; setting up and managing online stores using the Shopify platform; and analyzing data to drive sales and improve customer satisfaction.
€36 EUR in 40 days
5.0 (22 reviews)
5.1
5.1
User Avatar
Hi there, ★★★ Excel / VBA / Macros / Automation Expert ★★★ 5+ Years of Experience ★★★ I've read requirements and ready to create a complex excel formula. I provide complete ranges of solution for your Excel, Custom Formulas / Functions, Pivot Table, Dashboards, VBA and Macros Automation need. I can also provide similar past Excel work example before being hired. Services we offer: ✔️ Custom Formulas ✔️ VBA Macros Automation ✔️ Vlookup / Hlookup ✔️ Countif / Countifs ✔️ Converting CSV files in to specific format. ✔️ Export & import of Excel files in to specific excel file ✔️ Visual Basic User Forms, for user interface designing and dashboards ✔️ Interactive Pivot Tables and Graphs. ✔️ Converting Excel to PDF or CSV ✔️ Complete Dynamic VBA Macros Dashboards ✔️ Removing Duplicates from the File ✔️ Data Entry with automated process As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team
€36 EUR in 10 days
5.0 (7 reviews)
5.1
5.1
User Avatar
I understand you are looking for someone to create a complex excel formula that has 3 input parameters and 4 possible output parameters. I believe my skillset is perfect for this project. I have 3 years of experience in SOLIDWORKS ANSYS, FLUENT, STRUCTURAL ANALYSIS, CFD,FEA and vibration analysis which will be invaluable when it comes to analysing the input data. My background as a mechanical engineer will also be useful when it comes to creating the formula - I'm aware of the limitations imposed by Excel when it comes to functions that have more than 64 inputs at once. This is why I've created an example in column E which shows how the results for each link in the table should look like clusterized so they can be processed at once without affecting performance.
€36 EUR in 40 days
5.0 (24 reviews)
4.9
4.9
User Avatar
Please, I have fixed it for you. Kindly get in touch, review my work, and if you are okay, award the project to me. Thank you.
€36 EUR in 40 days
5.0 (15 reviews)
4.9
4.9
User Avatar
With over 7 years of experience in excel usage and an ACCA qualification, I have expertise in all areas of Excel, I can provide you with efficient, accurate, and insightful solutions to your data-related challenges. My Excel services include the following: Financial modeling: As an ACCA qualified professional, I have extensive experience in creating financial models in Excel. I can help you create complex financial models, including cash flow projections, discounted cash flow analysis, and financial statement analysis. Data analysis and visualization: I can perform various types of data analysis, including statistical analysis, data modeling, and regression analysis, and visualize the results using charts and graphs. I have worked with large data sets and can help you summarize and present your data in a meaningful way. Reporting and dashboards: I can create custom reports and dashboards to help you visualize and analyze your data, and make informed decisions based on the insights gained. I can also design interactive dashboards that allow you to explore your data in real-time. My development process includes an initial consultation to understand your requirements and objectives, followed by designing and implementing customized solutions to meet your specific needs. I am committed to delivering high-quality services and ensuring customer satisfaction. Please don't hesitate to contact me if you have any questions or would like to discuss your project further. Best regards,
€36 EUR in 40 days
5.0 (46 reviews)
5.0
5.0
User Avatar
As a professional Excel writer, I bid on your project because I have the expertise to deliver superior quality work. I guarantee you constant updates in the project as a way of ensuring the project meets your expectations. Please respond to the bid so that we can discuss the project exhaustively. Thanks in advance.
€36 EUR in 8 days
5.0 (4 reviews)
4.6
4.6
User Avatar
Dear client! I am interested in your project Excel Programming I have completed similar papers in the past and can assure you of exceptional and original work within the agreed deadline. I have skills in Excel and Data Processing. please contact me to discuss your project in detail. Regards. Sep} Hey! I can help you with yourExcel Programming at a high level! I have good experience in Excel and Data Processing. My skills and experience is a great match for your needs. Looking forward to hearing from you. Thanks.
€46 EUR in 114 days
4.9 (8 reviews)
4.1
4.1
User Avatar
Hi, I am an Excel, Power Query, VBA, & Power BI expert. I saw the shared sheet, I think a simple Switch formula would work in this case without any limitations. However, I want a few clarifications from you. The formulae you have mentioned are not making much sense, if you can simply list down cases for me, I will immediately put them in the formula and give you the solution. Maybe you can only explain the cases to me over chat if you dont have time to write them down. I will note as you explain and then simply put them in the formula. Lets discuss in chat, I can work long term. Thanks
€36 EUR in 40 days
5.0 (4 reviews)
3.3
3.3
User Avatar
Hello there! My name is Md. Akibul and I am a data processing, Excel professional with 5 years of experience in the field. I understand that you are looking for someone to create a complex excel formula that yields results in column D. I believe that I am the best fit for this project because of my extensive experience in data processing and Excel. Additionally, I have completed many projects involving data movement from one file to another as well as sending emails from Excel. This proves that I have the skills necessary to complete this project quickly and accurately. I'm available today and tomorrow to begin working on your assignment. Please don't hesitate to reach out if you have any questions or concerns!
€36 EUR in 40 days
5.0 (6 reviews)
2.6
2.6
User Avatar
Hi... come to chat. i can do this. i am interested and ready to work. i will finish this urgently.....................................................................
€36 EUR in 40 days
4.8 (7 reviews)
2.6
2.6
User Avatar
Hi ! I was able to solve your requirement, and have written a working formula in Excel. The formula was based on a reverse map, starting from "EMKG_E", then "EMKG_D" all the way to "EMKG_A", working on a sorted list based on the output (LEVEL1, LEVEL2, ... EXPERT). The formula itself, though, was written starting with ""EMKG_A", to facilitate tracking, and possible edit of the formula. Please send me a message, if you wish to discuss anything further. Thanks in advance ! Best regards, Tristan
€36 EUR in 1 day
5.0 (4 reviews)
2.4
2.4
User Avatar
Hello! My name is Zainab and I am a professional writer with extensive experience in Excel programming. I understand that you are looking for someone to create a complex excel formula that has 3 input parameters and 4 possible output parameters. I believe I am the perfect person for this project because of my extensive experience in Excel programming. Not only do I have the skills necessary to complete this project quickly but also ensure high quality results, but more importantly ensure that it meets your expectations by being professional, accurate and on time. Additionally, I am available for last minute requirements so don't worry about getting any work done unless you want it done. I look forward to hearing more about your project and helping you get more done!
€36 EUR in 5 days
5.0 (1 review)
2.0
2.0
User Avatar
Hello, You only used IF statement for when values in Column A are equal to EMKG_A. I have already created the correct logic and output values of column D for those values when column A is equal to EMKG_B. Let me know if you are interested in working with me. I will create the logic for the rest of them as well. Thanks.
€36 EUR in 3 days
5.0 (2 reviews)
1.3
1.3
User Avatar
Hello there, I think I could help you, if you sill are needing help. I have experience writing excel formulas Thanks, Ronald
€36 EUR in 10 days
5.0 (1 review)
1.1
1.1

About the client

Flag of GERMANY
Prague, Germany
5.0
51
Payment method verified
Member since Sep 26, 2018

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.