Find Jobs
Hire Freelancers

Create an excel formula to concatenate multiple cells into one cell with an if condition

$10-30 USD

Opravljeno
Objavljeno pred več kot 1 letom

$10-30 USD

Plačilo ob dostavi
I think this should be an easy request for a Excel guru, but I am not that. I need a formula that I can apply to every cell in a column that will concatenate values from multiple columns with an if condition. If the values are the same in another column then concatenate the value. I will upload a sample file of what I am looking for. I will try to describe the logic base on the file. The spreadsheet has a list of tests with Test IDs and Test Names. There is a column for the Location ID that the available test id/test name need to concatenate with ";" as a separator and fill the cell. This way all available tests for that location will be in one cell with a ";" separated between them. I need to be able to apply the formula to a file with 20,000 tests so the formula needs to work if pasted in every cell for a column.
ID projekta: 35357761

Več o projektu

76 ponudb
Projekt na daljavo
Aktivno pred 1 letom

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
$0 USD v 1 dnevu
5,0 (226 ocen)
8,4
8,4
76 freelancerjev je oddalo ponudbo s povprečno vrednostjo $22 USD za to delo
Avatar uporabnika
Hello, I am an Excel expert and I would like to help you with your formula. Please send me a message to discuss.
$30 USD v 1 dnevu
5,0 (501 ocen)
8,0
8,0
Avatar uporabnika
Hi Dan! I can help. Please send me chat so that I can send you the file. .
$15 USD v 1 dnevu
5,0 (430 ocen)
7,8
7,8
Avatar uporabnika
SIR", I am EXCEL formula's Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". 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 here from the last 1.5 year and I have 224+ 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
$45 USD v 1 dnevu
4,9 (215 ocen)
6,8
6,8
Avatar uporabnika
Hello, I will be glad to assist you with that. I am an experienced Financial & Business Analyst and Excel expert holding years of experience in Data Analysis, Data Visualization, Financial & Business Analysis. Lets discuss your project in detail and how I am highly suitable for this.
$20 USD v 1 dnevu
4,8 (193 ocen)
7,1
7,1
Avatar uporabnika
Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project performing the information in excel in detail. I'm so responsible and kind, I will always send you the files on time and with the best quality. Send me a message and I'll start working on your project. Politely, Giovanni.
$10 USD v 1 dnevu
4,9 (50 ocen)
6,9
6,9
Avatar uporabnika
Hi Sir, I can do this using a VBA macro within a few hours. Please invite for a chat. Thank you, Usman
$100 USD v 1 dnevu
5,0 (72 ocen)
6,9
6,9
Avatar uporabnika
Good day! Excel guru here, will apply the if based formula and will concatenate the results in single column Let’s discuss more in chat, looking forward for best deal and start of future relation Regards Atif
$20 USD v 1 dnevu
4,9 (95 ocen)
6,7
6,7
Avatar uporabnika
Greetings, Thank you for your detailing post. It seems you are looking for someone to Create an excel formula to concatenate multiple cells into one cell with an if condition. I'm working as a professional since 2017 in the Here, & local market. I think we can discuss a few more points on inbox, it will help to get the desired quality. If possible, please check my portfolio, hope you will get something interesting there. Overall, I am waiting for you to discuss this project. Thank you. Tanmoy
$10 USD v 1 dnevu
5,0 (172 ocen)
6,5
6,5
Avatar uporabnika
Hello, I am an Excel expert. I have read the project details, understand your requirements and I can help you in this task perfectly. Please check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid
$25 USD v 1 dnevu
5,0 (76 ocen)
6,0
6,0
Avatar uporabnika
I AM AVAILABLE RIGHT NOW ------------------------------------------------ Greetings! ----------------- I’m very much interested to your requirements and Job openings. I am a Professional in VBA Macro Excel with more years of experience, therefore, I can easily do this job. You can message me to discuss the detail and make sample for you. ---------------------- Mohamed A. ----------------------
$15 USD v 1 dnevu
4,9 (128 ocen)
5,8
5,8
Avatar uporabnika
Greetings Thanks for checking my proposal. I would concatenate accordingly and can start your project immediately. I am full- time freelancer having job experience of more than two decades. It included more than decade of experience as Manager in Public Listed Companies. Having In depth knowledge of Excel for data analysis, Pivot Table and charts, Dashboard, Power query, Macros, User Forms, Advance filters, VBA, Excel Solver, Advance dynamic charts, Financial reporting by using complex Functions. I have also developed many softwares in MS Access. It is my practice to do one project at a time therefore I would assist you full time according to your available time. You can check my scores and reviews Hoping for the positive reply from your side for a long-lasting working relationship. Regards
$17 USD v 1 dnevu
5,0 (100 ocen)
5,8
5,8
Avatar uporabnika
Hithere, I will help with the project on Create an excel formula to concatenate multiple cells into one cell with an if condition. I have read the instructions carefully and I clearly understand what is required of the project. I have handled several assignments in this field and I will be glad to offer my expertise and on this one too. With me, the quality and the deadline of your paper are my utmost priority. I have the expertise needed to complete your project as I have skills in Excel Macros, Data Processing, Excel and Data Entry. Feel free to contact me for more details. Thanks & regards.
$40 USD v 3 dneh
4,7 (18 ocen)
5,0
5,0
Avatar uporabnika
Greetings, I think you're looking for someone to create an excel formula to concatenate multiple cells into one cell with an if condition. I understand your project description very well. But can we discuss more about your project for kind of more information? I think I can do this task very effectively and also READY to start this project RIGHT NOW! So, please take a moment to chat with me. Sincerely, Dipty.
$10 USD v 1 dnevu
5,0 (17 ocen)
4,9
4,9
Avatar uporabnika
Hello, I'm a former CP (competitive programming) competitor, I'm a master at algorithms and could help you solve your problem quickly with clean, optimized and well-commented code.
$20 USD v 1 dnevu
4,9 (16 ocen)
4,3
4,3
Avatar uporabnika
✅ Excel Expert ✅ Microsoft Office Certifier ✅ Surely Delivery in 2 Days ✅ Immediate Start ✅ Offering you Professional IT Experience in Excel, data mining, web searching, Web scrapping and lead generation with over 5+ years experience working in all domains. What do we offer? ✅ Will update you in excel as you need. ✅ Daily work updates. ✅ Quality Work with 99.99% Accuracy ✅ Always on time ✅ Excellent Support. ⭐ Previous work available on request. I would be glad to bring my skill-set and expertise to work with you on your project. Feel free to send me a message to discuss your project with me, and I will respond right away!!! ? Hard work always appreciated ? Thanks & Regards, Pooja G.
$30 USD v 7 dneh
5,0 (13 ocen)
4,3
4,3
Avatar uporabnika
Hi there! As you’ve said, this is a very easy task, but a little more clarification on the logic would be awesome to ensure a 100% accurate result! Let’s chat, discuss more, and make this happen :)
$15 USD v 1 dnevu
5,0 (2 ocen)
3,1
3,1
Avatar uporabnika
” I am a Chartered Accountant + PhD(Scholar) writer with 7 years of excellence writing experience. I am expert in Excel with Macros, VBA etc. and confident to complete your project with 100% satisfaction. Thanks.
$20 USD v 7 dneh
5,0 (1 ocena)
2,4
2,4
Avatar uporabnika
Hello, I am professional freelancer with 3 years experience in Data analytics making me a suitable person for your project. I have more than 4 years of professional experience in Data analysis. Besides, I have skills in NLP Machine Learning (ML) using tensorflow. For your reference, you can check reviews\ portfolio for all the projects I handled so far. Hope to connect with you on personal chat. Regards, Mohamed
$20 USD v 1 dnevu
4,9 (5 ocen)
2,5
2,5
Avatar uporabnika
Hi. ⚡️⚡️ I checked your project detail and my skill are fitted in your project.⚡️⚡️ I have had rich experience in Editing, Typing, Data Mining, Data processing in Excel. I will do my best for your project. If you want to get good result contact me please. Thanks.
$20 USD v 1 dnevu
5,0 (2 ocen)
2,1
2,1
Avatar uporabnika
I can do this for you. Please view my past submitted work in my portfolio's Portfolio Items section.
$20 USD v 1 dnevu
5,0 (1 ocena)
1,8
1,8

O stranki

Zastava UNITED STATES
Attica, United States
5,0
4
Plačilna metoda je verificirana
Član(ica) od jan. 11, 2017

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.