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.
36 freelancers are bidding on average $23 for this job
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
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
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 :)