Excel or Smartsheet or Google sheets Expert needed

$8-15 AUD / hour

Completed

Posted

over 3 years ago

$8-15 AUD / hour

Looking for someone who is an expert on Excel or Smartsheet or Google sheets to help us achieve a formula to split text into multiple column and build then build up one cell that contains joined text in a specific format. Example, Step 1 A user selects Sizes (column 1) and Ingredients (column 2) from a multi select drop down in Smartsheets. I would be happy to do the same with Google or Excel sheets but it doesn't allow multi select in a dropdown, hence we used smart sheets for this task. Step 2 Goal is that we need to arrive at this exact text where Basil, goats cheese etc are the ingredient, Large, Standard, Small are sizes and PRICE is a constant text across. Basil=Large-[PRICE],Standard-[PRICE],Small-[PRICE]+goats cheese=Large-[PRICE],Standard-[PRICE],Small-[PRICE] There will be multiple sizes and large number of ingredients selected in Step1 so we need to formula to be flexible to cater to it. Pls apply for the project if you know how to achieve it. I will provide access to sample sheet.

Excel

Microsoft Office

Google Sheets

Project ID: 27425629

About the project

55 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Shodi39

Hi, I understand that you need a versatile formula that helps you extract the required exact result based on data provided. I can do this using a combination of array, lookup and srting formulae. I have over 8 years of experience in excel having woked as a data analyst, before R, Tableau or Python, using only excel to retrieve data meeting complex parameters. Looking forward to hearing from and working with you.

$12 AUD in 40 days

5.0

(1 review)

1.8

55 freelancers are bidding on average $11 AUD/hour for this job

@schoudhary1553

Hi, Greetings! ✅checked your project details: Excel or Smartsheet or Google sheets Expert needed ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast

$20 AUD in 40 days

4.9

(509 reviews)

8.4

@IgeS

Hi there, Is your requirement a customized price list or quotation? Please message if your ok to do it using app script in Google Sheet or VBA in Excel. I’ll be standing by to help. Ige

$10 AUD in 8 days

5.0

(47 reviews)

5.4

@BHARATBEURA

HELLO, MYSELF BHARAT. I’M A PROFESSIONAL DATA ENTRY EXPERT. I COLLECT DATA FROM PDF/WEBSITE AND FILL IN THE SPREADSHEET WITH DATA IN THEIR RESPECTIVE FIELDS. I WILL PROVIDE YOU WITH HIGH-QUALITY SERVICES IN REASONABLE DELIVERY TIME. FEEL FREE TO CONTACT ME AT ANY TIME. LOOKING FORWARD TO YOUR RESPONSE. REGARDS

$8 AUD in 40 days

4.8

(46 reviews)

5.3

@emilianoreyes70

Hello! I am an engIneer, Excel/VBA/Macro expert,Google Scrpit and Google Sheets expert . I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including the preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script). Regards, Juan

$10 AUD in 40 days

5.0

(24 reviews)

4.8

@Servicehour24

Dear Employer, You've specified that you need an Excel Expert. I am an Excel & Google Sheet Expert with 7+ years of experience. I would like to help you with confidence and satisfying results. I have worked on several similar projects and can deliver quality projects to tight deadlines. I can do this project very carefully within the provided time. I can manage 40+ hours a week for this job. Here is a sampling of the data entry projects I’ve completed: https://www.freelancer.com/projects/data-entry/Project-for-Abdul-26795214 https://www.freelancer.com/projects/data-entry/Build-list-blogs-266496677 https://www.freelancer.com/projects/web-scraping/need-professional-web-scraper-27100683 If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible. Best regards @Servicehour24

$12 AUD in 40 days

4.9

(7 reviews)

4.6

@KuldeepGera

Hello, I have worked with all three of them and got a rough idea of what you are trying to achieve, please provide the access of the sample sheet for me to be sure and we can proceed further. I can begin working on it as soon as I am hired. Initiate the conversation to discuss it in detail. I focus mainly on the quality of work. I assure the employer's satisfaction. Thus, most of my clients prefer to work with me again and I have a repeat hire rate of 55% which is highest among all the freelancers of my niche. Looking forward to working with you. Best Regards, Kuldeep Gera

$15 AUD in 40 days

5.0

(21 reviews)

4.5

@Leozida

Hi There, Interested in your posting and understood the request. Please share more detail if a size is considered with more than one ingredient? i.e. if you choose one siz, it will be limited to one ingredient or more, then the price will be fixed. This, in order to assess the work expected. feel free to invite/chat for a proposition. Looking to hear from you soon Thanks & Regards, Fethi,

$10 AUD in 30 days

4.9

(23 reviews)

3.7

@Sunitav36

HI, I have checked the project : Excel or Smartsheet or Google sheets Expert needed I am proficient in excel and i have 9+ Years of experience in Excel, i can make any reports with Automation, data cleaning , data extract, Visualization Dashboards and i shall give you 100% accuracy with timely deliver the project. To proceed further, I am ready to discuss your project and start immediately. Thanks

$11 AUD in 40 days

4.5

(21 reviews)

3.7

@MonicaMF

Hello, I can help you with the excel project, to split one text into multiple columns and create dropdown by multiples categories as needed. Best regards, Monica

$11 AUD in 40 days

5.0

(3 reviews)

2.0

@ADITYAPAWARFIFT2

We required 3 $ per hour only for this project. Greetings! I am a computer science student & Our team consists of experienced data entry and data analytics experts. We will provide perfect service in the shortest time. Please, give me more details about your project's details. I am sure, YOU WILL BE SATISFIED FROM YOUR SELECTION!

$8 AUD in 40 days

0.0

(0 reviews)

0.0

@Dadapeerhn

I m ready to do the project without fail Data entry is a type of clerical work that involves using various processes like typing and voice recording for entering data into computers.

$12 AUD in 40 days

0.0

(0 reviews)

0.0

@motiar10

Hello Sir, I read your description carefully. I understood what you require me to do and I am filled with confidence that I can complete your project wonderfully. I have experience with Data Typing, Data Entry and Microsoft Office and etc. I ensure: => 100% accuracy, => speed as lightening, => clear format. If you give me a chance, I will do my best to complete this project for us. I can complete this project with the best quality in time. I hope your kind reply. Best Regards. Motiar Rahman

$8 AUD in 40 days

0.0

(0 reviews)

0.0

@sk4585421

Hey there, I am very interested your projects. I have free time these days. So, i can deliver the work on time. Kindly, be sure that your work will we delivered with 100 % high quality. My name is shubham kumar. i went to get your work done as quickly as possible. Thank you.

$8 AUD in 40 days

0.0

(0 reviews)

0.0

@Ranajitghorai

Give me this project I will do it very fast. I am expert in Microsoft office and excel. Within 24 hour

$12 AUD in 40 days

0.0

(0 reviews)

0.0

@maham1337

HI, I have checked the project : Excel or Smartsheet or Google sheets Expert needed I am proficient in excel and i have 4+ Years of experience in Excel, i can make any reports with Automation, data cleaning , data extract, Visualization Dashboards and i shall give you 100% accuracy with timely deliver the project. To proceed further, I am ready to discuss your project and start immediately. Thanks

$8 AUD in 101 days

0.0

(0 reviews)

0.0

@digitalcareer21

Hi I have experience in data entry field more than 5 years. I can complete this project with full efficiency that will make your business to organize and make wise decesions. Regards

$8 AUD in 40 days

0.0

(0 reviews)

0.0

@DrpardeepSharma

Hi I have read your description and ready to work on it if you are agree on bid. I have more than 7 year experience on MS excel, Google excel and Pivot table. Regards Dr Pardeep

$9 AUD in 4 days

0.0

(0 reviews)

0.0

@nishantkashyap30

Hi I am Nishant Kashyap. I have tipping experience because of I worked for lot of data entry company in Chennai as well as completed Excel Course during Engineering. and I have Excel expect certificate. I think which will more helpful to do your work.

$9 AUD in 39 days

0.0

(0 reviews)

0.0

@pradeeprana1513

Hi! I am an Tally, Excel, Word (M.S. Office & More Softwares) Expert with Professional experience working with Excel both with Formulas and Macro, Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I can complete your project on time and within your budget with utmost care and no compromise on quality. I look forward to working with you. Thank you.

$15 AUD in 40 days

0.0

(0 reviews)

0.0

@AnowarHossenbd

just saw your requirement. this job is very creative work. I am the right person for doing this job. If you hire me I will complete the job perfectly and accurately and deliver on time. Feel free you can make the job with me. Thanks & Regards. Anowar

$9 AUD in 30 days