Find Jobs
Hire Freelancers

Create a complex excel formula

€12-18 EUR / hour

Closed
Posted about 7 years ago

€12-18 EUR / hour

Hi. I'm looking for someone who understands excel well to create a formula for us. You will need to understand the "lookup" function and the job will be to automatically transfer and calculate data from one tab to the appropriate cells in another tab from the same spreadsheet. It should be a fairly quick job for someone who understands what to do.
Project ID: 13530071

About the project

56 proposals
Remote project
Active 7 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
56 freelancers are bidding on average €15 EUR/hour for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€16 EUR in 40 days
4.9 (368 reviews)
8.1
8.1
User Avatar
Hello I am Excel Expert and VBA Programmer ( for macros) If interested, let me know, I can help with any task in excel Thanks & Regards
€12 EUR in 5 days
5.0 (210 reviews)
8.2
8.2
User Avatar
Hi There, I'm happy to help you on this task. I am one of the most trusted excel experts in this site, and have already done lots of advanced excel assignments. I'm ready to start this project and look forward to hearing form you soon. Best regards Priyal
€15 EUR in 2 days
5.0 (196 reviews)
6.8
6.8
User Avatar
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please contact me to discuss the details. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
€20 EUR in 3 days
4.8 (195 reviews)
7.1
7.1
User Avatar
Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, WEKA and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
€50 EUR in 40 days
4.8 (83 reviews)
6.8
6.8
User Avatar
Hello, I graduated from Boston University USA, which is among top 50 Universities of the world. After my education, I worked in the field on different positions. I have total experience of 19 years now. I can work for you at US $ 8.00/hour. I have lot of experience of Data Management and excel spreadsheet.I know the value of time. I am very hard working and always deliver work on time, with 100% accuracy. My personal qualities are: - Details Oriented, as handled many sensitive contracts in past. - Trustworthy and honest. - Very Fast Learner. Looking forward to speak to you soon! Thanks you Best Regards
€12 EUR in 40 days
4.9 (10 reviews)
6.2
6.2
User Avatar
A proposal has not yet been provided
€12 EUR in 30 days
5.0 (52 reviews)
5.9
5.9
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I can start working on the project immediately and complete the job within some hours. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards
€12 EUR in 2 days
4.9 (64 reviews)
5.7
5.7
User Avatar
- Have expertise in Vlookup, Hlookup, formula arrays and other formulas, pivots in Excel VBA automation and scripting. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - University, US - Scoring the answer sheets based on keyword and number of occurences.
€15 EUR in 40 days
4.7 (51 reviews)
6.0
6.0
User Avatar
I am a skilled freelancer who has a working experience of more then 4 year I have working experience on- Web Research, lead generation, data entry, data mining, lead collection, All types of scrapping tools like - data toolbar, web hearvy, VWR etc..... I have great experience that would fit best. if hired by you i will deliver work of high standard and provide exceptional contribution in serving your task.
€12 EUR in 40 days
4.7 (47 reviews)
5.6
5.6
User Avatar
Greetings! My name is Iqbal Ali. I am an Excel expert with great customer feedback, excellent Upwork test score, and committed approach to project handling. I am expert with vlookups, pivot tables, pivot charts, graphs, conditional formatting, if, or, and, concatenate, filters, and other advanced functionalities. Can you please share your Excel file and your requirement with the lookup function? Thanks, Iqbal Ali
€12 EUR in 40 days
4.2 (12 reviews)
5.3
5.3
User Avatar
Dear sir I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. feel free to contact me over the web site chat for further details brgds. Itay
€13 EUR in 10 days
5.0 (12 reviews)
4.3
4.3
User Avatar
Hello, I am Prajwal Bhatt, a pre-final year student at IIT Roorkee. I am a creative, flexible and focused individual who is passionate about Data Science, Natural Language Processing and the entire Analytics space. I'm proficient in R programming, Python & Microsoft Excel and have acquired knowledge of Weka and C++. I have applied my knowledge of analytics to prepare and analyze models, based on various case studies. I have an experience of working as a data science intern in five companies/start-ups before; Razorpay, Loanmeet, Vamanetra Digihealth, Gyandhan and KUAI (Isarel, Remote intern). I am proficient in all look up functions in excel including VLOOKUP, HLOOKUP, INDEX & MATCH functions. Let's discuss the prospect over chat so that I can understand your requirements better.
€12 EUR in 40 days
4.8 (20 reviews)
4.5
4.5
User Avatar
Dear Hiring Manager, I want to do your job/project now, let's start immediately. I have read the job description. Please send me the excel file with data. I'm knowledgeable with lookup, vlookup and hlookup functions. I've been working in a BPO company for more than 13 years now. My job there honed my skills to be a web search expert, MS Excel expert & MS Word expert. I have good analytical skills and I'm very keen to details. I'm a returning freelancer (not searched and accepted jobs/projects for a few years) so please give me a chance and read my past reviews. My typing speed is 35wpm. I'll try my best to complete it on time and I guarantee 100% accuracy in all my works. I'm available for work on your job/project at this Philippines times (UTC/GMT +8 hours): 5 hours during weekdays (10am-3pm PHT) 10 hours during weekends (10am-8pm PHT). Regards, Oliver
€13 EUR in 40 days
5.0 (14 reviews)
4.2
4.2
User Avatar
A proposal has not yet been provided
€13 EUR in 10 days
4.7 (12 reviews)
4.2
4.2
User Avatar
Hello, Greetings for the day, The requirement you mention is very easy task for me, I am very much used to with Vlookups and Hlookups. Please share your project details with me in personal chat. I will be looking forward to hear from you. Thanks & Regards, Irfan Shekh, Shekh Info. Solutions
€16 EUR in 40 days
4.8 (5 reviews)
4.1
4.1
User Avatar
Hello. Could you have a quick chat session with me? I would like to understand your project in more detail and so adjust my bid based on the information that you can provide. I have a video in my profile showing the final results from one of my last works and can share another that I have ongoing as well. I can create the formulas that you need. I have more than 20 years of experience working for multinational companies such as Avon Cosmetics and Etex Group, performing different kinds of data analysis and reports. I specialize in provide solutions for Business Administration, Data Base management, Business Key Performance Indicators design, Production Planning, Purchase Planning and Project Management for industrial companies. I am also able to develop complex and automated VBA programs to automate Excel spreadsheets and other applications. I guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. My work will give you the confidence to initiate a long term relationship. Thank you.
€16 EUR in 6 days
5.0 (11 reviews)
4.0
4.0
User Avatar
Hey Hi, I am an excel expert and have done numerous projects. I can understand your requirement quickly and delivery a QUALITY outcome. Message me so that we can discuss the details and take it forward. Regards, Dinesh V
€16 EUR in 40 days
4.7 (7 reviews)
3.0
3.0
User Avatar
-Expertise in Excel work. -High quality formating and 100% error free work can be expected. -codes will be shared for your reference -Quick turn around time
€15 EUR in 40 days
4.9 (4 reviews)
2.8
2.8
User Avatar
Dear Client Greetings! I maybe new in Freelancer and have no any scores/ratings yet. However, I am not new or beginner in this kind of job as I have been doing this since 2010 for a global company. Responsible in handling (consolidate, edit, update, merge etc.) personal information (Id#, Name, Position Title, etc.) of 40,000+ employees using Excel. I guarantee that I am able to accomplish the task immediately as I am proficient with excel not limited to pivot table, graphs, different formulas, data validation, conditional formatting and Macro. Thank you for considering me with this post. Ron
€13 EUR in 40 days
5.0 (2 reviews)
1.8
1.8

About the client

Flag of SPAIN
Spain
0.0
0
Member since Mar 27, 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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.