Käynnissä

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

About the Employer:
( 14 reviews ) Madrid, Spain

Projektin tunnus: #13081108

Myönnetty käyttäjälle:

fariaakterdia

Hi, I have read through your project description. I will work as per your direction with 100% accuracy. And I will deliver your project before your time-line. I am waiting for your response to discuss more about the pr Lisää

20 € EUR 1 päivässä
(5 arvostelua)
2.1
ZedExcel

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ä
(21 arvostelua)
4.5

19 freelanceria on tarjonnut keskimäärin 23 € tähän työhön

KulfiSoftwares

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ä
(94 arvostelua)
6.1
schoudhary1553

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ä
(105 arvostelua)
6.1
teeares

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ä
(46 arvostelua)
4.8
asifdwan

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ä
(46 arvostelua)
4.6
mladenbiz

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ä
(15 arvostelua)
3.8
bilalmaher053

HI, can i ask some thing about rules ?

12 € EUR 1 päivässä
(7 arvostelua)
3.0
scorpionobaid01

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ä
(6 arvostelua)
2.8
goyalfreelancer

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ä
(1 arvostelu)
0.9
23 € EUR 1 päivässä
(2 arvostelua)
0.9
deja908

A proposal has not yet been provided

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

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)
0.0
sanjogdandasena

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)
0.0
CLAYZOL

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)
0.0
techwizards2

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with [url removed, login to view] mainly deal in web development, SEO, Android App, software testing and graphic design. Our vision is to b Lisää

22 € EUR 6 päivässä
(0 arvostelua)
0.0
himsyaal

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)
0.0
tompruden

A proposal has not yet been provided

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

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)
0.0
jitenderpal0703

A proposal has not yet been provided

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