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)
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.
18 freelance font une offre moyenne de €23 pour ce travail
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 Plus
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 Plus
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
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 Plus
Please provide details of all the conditions for both columns E & F. I can do it using formulas or a a vba script.
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 Plus
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 Plus
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
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
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 Plus
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.
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 Plus