Completed

Excel function

I need a excel function to do this

See example file attached

I have in a tab in Colum A colum H and Colum I values

I want to have a function that combines and replace values.

Value in Colum A + Value in Colum H and Colum I needs to be combined like this

Value A, Value H, Value I

But when the value in colum H is root, ignore this value and only print colum A and I

So Value A, Value I

Same if value in Colum I is root or empty only print Colum A + H

Value A, Value H

Skills: Excel, Visual Basic, Data Processing, Software Architecture, Data Entry

See more: excel function open url, excel function morgage payment, lotto excel function, excel $ function shortcut, excel $ function meaning, excel functions pdf, excel functions if, advanced excel functions, excel functions tutorial, excel functions with examples, common excel functions, excel function creator, excel function maker, report excel function oracle apps, java call excel function, excel function extract numbers phone numbers, cut paste vba excel function, excel function list, implement financial excel function rate, excel function pictures

About the Employer:
( 14 reviews ) Vlierzele, Belgium

Project ID: #26391503

Awarded to:

MimiFL

Hi, this is very simple, and i can write this formula for you in matter of minutes. If you are interested in working with me, feel free to message me and i will help immediately. Thanks, Milan

€10 EUR in 1 day
(581 Reviews)
7.1

17 freelancers are bidding on average €16 for this job

(333 Reviews)
7.9
(432 Reviews)
7.1
AnowarRatul

-------------------I CAN START RIGHT AWAY 100% ACCURACY------------------- Hello sir, I have seen you attachment and understand clearly. I can Solve this by maintaining 100% accuracy of your data absolutely as you wan More

€8 EUR in 1 day
(125 Reviews)
5.5
MartinDudumi

Hi there, I'd like to be considered for your request. I’m a data guy with a strong background developing several excel tools including vba automation and complex formulas and functions applied in excel and I can ass More

€25 EUR in 1 day
(26 Reviews)
4.8
(16 Reviews)
4.4
muhammadumar84

Hi, I have gone through your project placement & it matches my expertise, I understand that you are looking for an expert in excel for combine & replace function. EXPERIENCE: 13 Years EXCEL: I can automate processes, m More

€8 EUR in 1 day
(5 Reviews)
2.1
Akshayarajan

Hi, Have understood what you are looking for. Will use an if function and concatenate to basically club the elements. About me - I'm a business finance professional having 5+ years of experience working with Excel T More

€10 EUR in 1 day
(2 Reviews)
0.7
INDIKAWIC

Dear friend, I am Expert for Excel functions, so I can do this as you wish, also this job 100% match with my capability and current works I am performing in Freelancer and Professional carrier. Please give me chance More

€8 EUR in 7 days
(0 Reviews)
0.0
€12 EUR in 1 day
(0 Reviews)
0.0
balarkbiva

Thank you so much Relevant Skills and Experience I am expert

€23 EUR in 1 day
(0 Reviews)
0.0
abdullahsajjad42

Dear Sir I have read your requirement I can do this with the excellent work. I have an experience of Data entry since 2 years I can solve your problem. kindly send me the details

€14 EUR in 1 day
(0 Reviews)
0.0
rathoddasharath

Hi there! I'm experienced and skilled in MS Excel. I have great attention to detail and I'll be able to transform your data into a spreadsheet quickly and accurately. I have high professional experience in Excel and More

€8 EUR in 2 days
(0 Reviews)
0.0
MALIK878

I am expert in excel work and work for many companies.i will do this project for you as you want.I will finish this project only in one day.

€15 EUR in 1 day
(0 Reviews)
0.0
KOKKANTI80990

HI SIR I WAS INTERESTED TO COMPLETE YOUR PROJECTS WITH HIGH QUALITY AND THAT ALSO WITH IN THE TIME PERIOD YOU WANT SO PLEASE MAKE US A CHASE FOR COMPLETE YOU PROJECT THANK Y More

€12 EUR in 5 days
(0 Reviews)
0.0
abdulmalik41

Hai Mungkin ini bisa jadi pertimbangan anda Saya lukusan IT untuk pekerjaaan ini saya yakin kalau saya mampu untuk menyelsaikannya Relevant Skills and Experience Speed typing Excel Word Design

€23 EUR in 1 day
(0 Reviews)
0.0
€14 EUR in 1 day
(0 Reviews)
0.0