Google Sheets: advanced search

You can see an example sheet on [url removed, login to view]

Given some information (Sheet 1 column A and also Column D), there will be some rules to determine values for columns E and F. Sheeet named Rules is where you will find conditions to be applied in order to determine Type and Code.

At Sheet 1 column E you will find a primitive approach, using IFs and REGEXMATCH, and not enough to do all I need.

You can do it by formulas or Script, as long as I can edit final result to include all conditions I want (I know very basic Javascrip)

Taidot: Excel

Näytä lisää: google adwords search advanced, pass google search advanced exam, google search advanced exam, code search business name google map, google code search project j2me sms bluetooth, google code search j2me sms mobile application bluetooth, ads google code web search java, search form frontpage google, zml search advanced, search businesses within google maps radius, bring search result top google, search suggestion ajax google, php search script using google api, google search keyword position asp code, wordpress plugin search advanced, bring search results top google, adwords codes search voucher links google, add google code cre loaded, google checkout type product, search engine based google, openmeetings google code description, search engine similar google, updating excel sheets manually code visual basic, search advanced joomla

Tietoa työnantajasta:
( 14 arvostelua ) Madrid, Spain

Projektin tunnus: #13081108

Myönnetty käyttäjälle:


Hi. Hope I'm not too late in bidding. I've come up with a formula that will achieve your goal. Drop me a message if you haven't found a solution yet.

€30 EUR 0 päivässä
(30 Arvostelua)

18 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lisää

€50 EUR 1 päivässä
(210 arvostelua)

Expert at excel automation. ZERO ERROR GUARANTEED!! Please read my 160+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction gu Lisää

€30 EUR 1 päivässä
(195 arvostelua)

Hi there! I am an expert on any data entry jobs and I’ve lot of experience on this type projects.. I’m ready to start it right away. I look forward to hearing from you. Regards

€23 EUR 1 päivässä
(134 arvostelua)

HI, can i ask some thing about rules ?

€12 EUR 1 päivässä
(86 arvostelua)

Hi, I'm experienced in this type of work. I would be happy to work for you. If you're interested in hiring a reliable freelancer please contact me with details. I'm very enthusiastic when it comes to computers an Lisää

€23 EUR 1 päivässä
(51 arvostelua)

Please provide details of all the conditions for both columns E & F. I can do it using formulas or a a vba script.

€12 EUR 1 päivässä
(50 arvostelua)

Hi I am here to assist u inthis project I am an acca member currently wor in finance dept of Qatar Airways Have great skill and exp in excel can assist u with high regards Plz share more info to proceed Thanks Lookin Lisää

€15 EUR 0 päivässä
(12 arvostelua)

Hi, I'm Sahil I have 2 years working experience on data entry and web search. I already done some work like bank statements, student record and customer information on excel. I will be provide you 100% accurate data wi Lisää

€30 EUR 1 päivässä
(3 arvostelua)
€23 EUR 1 päivässä
(2 arvostelua)

im a python developer... i can build a bot for these entries ..... i need to know the sheet details ... further i can enter and make by your own

€24 EUR 1 päivässä
(0 arvostelua)

A proposal has not yet been provided

€14 EUR 3 päivässä
(0 arvostelua)

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?

€16 EUR 1 päivässä
(0 arvostelua)

A proposal has not yet been provided

€18 EUR 3 päivässä
(0 arvostelua)

I understand this project to the best of my knowledge and I will work to the demands and needs of the of the project. My skills in working with Excel office program for at least 7 years will make me a reliable and eff Lisää

€23 EUR 1 päivässä
(0 arvostelua)

Dear sir I can guarantee fast and efficient data entry using Excel to make well sorted spreadsheets and if you are satisfied with my work, feel free to contact me for any further jobs.

€34 EUR 3 päivässä
(0 arvostelua)

A proposal has not yet been provided

€12 EUR 3 päivässä
(0 arvostelua)

I am expert of work with years of work experience, very much proficient with Data entry job, Excel work and typing. I am also very curious about my job and doing job with more interest and patience. I am very much time Lisää

€22 EUR 2 päivässä
(0 arvostelua)