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)
Décerné à :
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.
19 freelance ont fait une offre moyenne de 23 € pour ce travail
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
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
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.