Find Jobs
Hire Freelancers

Create Excel formula (advanced users only)

$30-250 AUD

Fullført
Lagt ut omtrent 4 år siden

$30-250 AUD

Betalt ved levering
Please note, this job has been started and then rejected by two Freelancers now because it was too difficult - only bid on this job if you know you can solve this. I have a list of numbers (units within our building) that I need users of the workbook to enter into a cell. I need to restrict users to entering either a single unit from the list, or multiple, in the following format (without the quotations): "[unit]" "[unit], [unit], [unit]" etc. Note here that the units are separated by a single comma then a space. I am not able to write a macro for this as the file needs to stay in .xlsx format. So I need a formula to check whether the cell is in one of these formats. The attached file shows what that formula would return if entered into column B. This needs to be completed within 24 hours and budget is $50.
Prosjekt-ID: 24043200

Om prosjektet

44 forslag
Eksternt prosjekt
Aktiv 4 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
Hi, I have a working solution, it is ready. No macro, so the file will still be .xlsx format. Thank you.
$50 AUD om 7 dager
4,9 (102 omtaler)
6,1
6,1
44 freelancers are bidding on average $71 AUD for this job
Brukeravatar
Hello, I can help you with your project - Create Excel formula I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$100 AUD om 2 dager
4,9 (486 omtaler)
8,3
8,3
Brukeravatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Contact me to discuss the details. Best regards
$50 AUD om 1 dag
5,0 (319 omtaler)
7,4
7,4
Brukeravatar
Hello, I am financial expert and guru in Excel with extensive knowledge and expertise in advanced formulas, pivot tables, tables, and visual basics, including preparation of graphical and visualisation reports dynamic dashboards, and charts. I deal with exporting and importing databases and create automation with VBA. My modules allow to fill and validate information on forms (with drop-down list ) and to add them in structured tables and build-in reports. Furthermore, I have experience in accounting, financial statements, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, long term debts, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic & designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.
$140 AUD om 1 dag
4,9 (93 omtaler)
7,4
7,4
Brukeravatar
I can perfectly do this with advance Excel formula as well as with VBA within 12 hours for 45. I am a professional Excel expert holding years of experience in Excel, VBA, SQL, Power BI, Tableau and various other tools to perform automation and develop dynamic and automated tools. I will be happy to discuss in detail how I am highly suitable for this project.
$45 AUD om 1 dag
4,8 (183 omtaler)
7,1
7,1
Brukeravatar
Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your 24hrs . Please send a message so we can discuss more & start the project. Thanks
$50 AUD om 1 dag
4,9 (259 omtaler)
6,8
6,8
Brukeravatar
$39 AUD Only ------- In just 3 Hours ------- I can build the complex excel formula to check the format of data absolutely as you want ------ Excel VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting ------ I can start right now, please message me to discuss more. ----- I can send you draft right now to ensure my expertise.
$39 AUD om 1 dag
5,0 (372 omtaler)
6,7
6,7
Brukeravatar
Hello, I have written an Excel formula to restrict users to entering either a single unit from the list, or multiple already. Let’s discuss if you’re interested. Best regards, Duong
$50 AUD om 1 dag
4,9 (60 omtaler)
6,4
6,4
Brukeravatar
I am an Excel expert and have read the description. Probably you missed to attach the file. Please share the file with me. I am ready to work on it right now. Regards
$50 AUD om 1 dag
5,0 (148 omtaler)
6,4
6,4
Brukeravatar
Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.
$50 AUD om 7 dager
5,0 (117 omtaler)
6,5
6,5
Brukeravatar
Hi there, A custom formula as an add-in is ok? Please share me the file. I’ll be standing by to help. -Reggie
$50 AUD om 1 dag
5,0 (43 omtaler)
5,4
5,4
Brukeravatar
Hi there, I can get you the formula you need, if you can share the file that you have mentioned in your post. It will then be clear what out put you want when you enter units as per the format you explained. Regards Reuben
$50 AUD om 1 dag
5,0 (24 omtaler)
5,1
5,1
Brukeravatar
Hello Client, I have checked your requirement. I have good experience (14+) in Dashboard creating while using Excel, Advance Excel, VBA, Graphs & Slicer. Let me know if you want to hire me for your project. Thanks, Jitender Kumar
$50 AUD om 7 dager
5,0 (24 omtaler)
4,7
4,7
Brukeravatar
Hi There, I have read your descriptions, please attached your file so we can excactly understand what you needed. Please kindly chat me. Thank You.
$50 AUD om 1 dag
5,0 (23 omtaler)
4,8
4,8
Brukeravatar
Hello, I am happy to inform you that I have read your current project description and understood all of your required requirements. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into an excel sheet. I am very responsible for my clients and I can complete the task within time with cent percent accuracy. Regards https://www.freelancer.com/u/Servicehour24 Servicehour24
$50 AUD om 2 dager
4,9 (7 omtaler)
4,6
4,6
Brukeravatar
Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs i can write the required formula in the next 24 hours samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ ⭐⭐⭐⭐⭐ waiting your answer Regards
$30 AUD om 1 dag
5,0 (54 omtaler)
4,5
4,5
Brukeravatar
Hi there. Benne from Singapore. I saw your project earlier but I had something on. you previously uploaded a file but probably forgot this time. love a challenge and tried to solve your problem. unfortunately, i don't think you can do it straightforward in a data validation custom formula. the limit is 256 characters and it requires a crazy array formula to do it (for the checking of duplication). since vba cannot be used, how about a helper column? in column D for instance. the crazy formula will be in column D and column B just have to check if column D is true or false. Edit: i have done the formula and can show you a demo before you award.
$50 AUD om 1 dag
4,9 (8 omtaler)
4,2
4,2
Brukeravatar
Hi sir, I have gone through your description of task. I couldn't find attachment in this project post. Please share the file so i can view and get an idea of what exactly you are willing to have. Apparently it seems fine for me in developing this code. But Let me go through file, will discuss with you and confirm you about the completion of the task. Let's discuss this in details. I'm available and can start work on it right away. Let's talk to get it completed in your given deadline.
$50 AUD om 1 dag
5,0 (4 omtaler)
3,5
3,5
Brukeravatar
Hi, My name is Vivek. I am a macro expert and l am very good with excel formulas.I have read through the details from which I got a basic idea. If you could share the data file with me , I would like to try . I am not asking to award the project to me. Just let me try. Once I see the data file I will if it is something which I could I achieve or not. If can make it work I will do it as quickly as possible and based on the outcome we can go ahead with the project. Please message me. Thank you Vivek
$50 AUD om 7 dager
5,0 (6 omtaler)
3,3
3,3
Brukeravatar
Greetings, Through the most part of my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources and made it easily usable using Excel. Provided numerous solutions in Excel using functions & formulas and very innovative Pivot table features. Keen to take up this assignment. I have worked out the solution and will provide the same. Thank you for taking the time to read my proposal. Warm Regards
$50 AUD om 1 dag
5,0 (3 omtaler)
2,6
2,6
Brukeravatar
hi! yes, to enable macro you need the extension to be xlsxm or xlsm. since we cant do that, we need to do it with formulae and functions. the rest of the things are ok with me...so, let me know your remarks. thanks.
$50 AUD om 1 dag
3,5 (4 omtaler)
2,3
2,3

Om klienten

AUSTRALIAs flagg
Brisbane, Australia
4,9
32
Betalingsmetode bekreftet
Medlem siden jun. 1, 2016

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.