Closed

Rewrite excel formulaes for import in a tool

We have some sheets where we want to import the fomulae in an other application. So we have the following assignment rewrite the excel formulaes accordingly. We have some rules, each formula should refer to a table and column.

We have two kinds of tables - with ID and without. With ID we do not need to use the VLOOKUP formulae since this is automaticly in the tool (1), just use: VALUE(TABLE(COLUMN) for numbers and CONCATENATE for text in the formulae.

(2) IF there is no ID we use the index function: so use INDEX(TABLE[COLUMN], position*].

* Position is the number (vertical).

(3) For summaries use the sum function: SUM(Table[Column])+SUM(Table[Column])

Please only respond if you are experienced and can deliver fast.

Skills: Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic

See more: excel chart generator tool, excel excel code import spreadsheets, excel quickbooks import using xml, excel import data from another workbook vba, importing text file into excel using vba, automatically import data into excel, convert text file to excel 2013, convert text file to excel 2016, import text file into excel 2016, import multiple text files into excel, import data into excel from another excel file, web based excel import tool, excel files import output php, excel data import template, excel template import example, excel php import, excel template import data visual basic, excel template import, joomla import tool, excel vba import excel sheet excel sheet

About the Employer:
( 17 reviews ) Zwolle, Netherlands

Project ID: #18095088

18 freelancers are bidding on average $117 for this job

DataHome

Hello there, Team of Excel experts here with proven track record Let us handle your project with guaranteed time and low budget We would like to talk further about moving forward Waiting for your good reply Kind More

$30 USD in 3 days
(69 Reviews)
8.4
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 ( More

$200 USD in 3 days
(650 Reviews)
8.3
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Rewrite excel formulaes for import in a tool. I can assure you the quality job. I have good experience in Data Entry, Data Processing, Excel, More

$250 USD in 3 days
(308 Reviews)
7.7
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD in 3 days
(289 Reviews)
7.2
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega More

$100 USD in 3 days
(216 Reviews)
6.8
prameswara

Hello Sir im excel VBA macro and formula Expert :) i can do make formula table like u need in project description :) please give me this job and im able to start working right now Thank you Galih

$55 USD in 1 day
(334 Reviews)
7.0
zekovicm

Hi there,I am Miljan,excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag More

$155 USD in 3 days
(112 Reviews)
7.1
chriskerpini

Hello, My name is Chrys. As you can see from my profile, I have 18+ years experience working with Excel/VBA and 14 years teaching them both (all levels). I can certainly do excellent work with your project. Please c More

$100 USD in 3 days
(81 Reviews)
6.7
datadexterous

Hello there! I have read the project description carefully and would like to be considered for the work. I can deliver the work within your asked guideline and revised it till its work for you. Hope to chat with More

$150 USD in 2 days
(140 Reviews)
6.2
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 Khan

$155 USD in 3 days
(90 Reviews)
5.9
The24CarrotsInc

Hello, We can do this with 100% Quality with On-time delivery. Please allow us to take this opportunity. Thanks.

$100 USD in 1 day
(68 Reviews)
5.8
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you More

$98 USD in 3 days
(102 Reviews)
6.2
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. OK. Sure. Let me check and analyse the volume of work. Willing to take up More

$155 USD in 3 days
(68 Reviews)
5.8
usmanhassan123

phd in computer science having seven years of experience in Excel development.

$100 USD in 1 day
(49 Reviews)
5.9
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com More

$111 USD in 2 days
(31 Reviews)
4.9
webanis

Hi, I am interested in your offer. Let me know more details about this work. I will start working immediately :) Br;

$75 USD in 1 day
(18 Reviews)
4.1
Karicke

I have extensive excel knowledge and will be able to assist you with the task in no time. I have a lot of knowledge with most Microsoft knowledge and post project assistance

$72 USD in 1 day
(8 Reviews)
3.1
coorymak

I have read over your job description and would love to have the opportunity to discuss with you further about this project. I hope to hear from you soon.

$100 USD in 3 days
(0 Reviews)
0.0