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.
18 freelancers are bidding on average $117 for this job
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
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
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