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)
19 freelanceria on tarjonnut keskimäärin 23 € tähän työhön
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
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.