I have a spreadsheet in Excel with the fields COMPANY, EMPLOYEE. The COMPANY field is the company record with 11 digits. There are companies with about twenty employees. The employee's CODE (COD_EMPLOYEE) field should be the 11 digits of the COMPANY field with four sequential digits (0001, 0002 ...).
I want add data in COD_EMPLOYEE with this rule. Example:
COMPANY EMPLOYEE COD_EMPLOYEE
16001051247 JOAO 160010512470001
16001051247 MARIA 160010512470002
16001050822 PEDRO 160010508220001
I need a formula to put in that field to do that job.
I am expert in MS Office Excel. I can complete the job in the shortest time. If you like to switch to database from spreadsheet, I can give you some consultancy about it. My proposal is the minimum fee, to make up my Daha Fazla
Bu iş için 34 freelancer ortalamada $24 teklif veriyor
I love excel automation, and am an expert at setting up formulas.. Can setup the formula for you to populate the code. ZERO ERROR GUARANTEED!! Please read my 300+ reviews. I am here to impress you with my work.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
hello i want to do this job please allow me to start sampling .contact me anytime i am always here. Relevant Skills and Experience Excel, Additional Services Offered in case of any problem in file the rewo Daha Fazla
Please review my profile as i have relevant skills and experience required for this project. Send me a message to start now. Thanks, Asad Khan
I can get this done for you now using a combination of TEXT and countif, and concatenation. I love working with this kind of text manipulation in Excel!
Greeting, I have understood your Excel job task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel
Hi, I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel m Daha Fazla
I am a professional with years of experience with excel and can complete your project in an hour as you have described
Hi, I'm an specialist in data science and business intelligence. I have huge experience working with data and developing systems and databases for pymes. We can help you on that requirement.
Good afternoon. I consider that I am the best candidate for this job, since I have the necessary experience to carry out the request. The work will be done with excellence and delivered in a timely manner. For your att Daha Fazla
Dear Sir, It would be a pleasure for me if you accept to work together. The file will be ready in 30 minutes maximum. Regards.
Hello, I'm Nour, i have worked on various types of projects on Excel anx i have the right skills for your project, i'll graceful if you give me the chance to work with you. Best regards, Nour.
It is an easy task. I can do it for you instantly. I am an external auditor who works on excel on a daily basis. Contact me to let me provide you with the formula :)
Greetings Sir/Mam, I have 5 years of experience in data entry and research and web-scraping, I also do VBA programming as well as VB.net, I am confident I can do this job right now and provide the formula. I am exce Daha Fazla