Replace same values with different names

P

prasath95662

New member
Joined
Jun 12, 2020
Messages
6
Reaction score
0
Points
0
Excel Version(s)
2007
Hello all,
A B C D E F
L L L L L L

I Have a file which consist of an employee leave data which are in different dates. I need to replace with L1,L2,L3,L4,L5. If an employee is taking 5 leaves it need to be filled till L5. Another employee is having 3 leave then it need to be completed till L3 alone. If an employee is taking more than 5 days it should be filled with CL1, CL2.....

Kindly help on this.


Thanks in advance
 
Please attach a sample workbook with a small mock-up of what you require.
 
I have attached the sample work book in this. In this I need for an employee if L is updated ie. leave is updated it need to be changed to PL1. If the same employee took 5 days leave it need to be updated from PL1 to PL5. After that if the employee takes leave it need to be changed to CL1,CL2....so on.

Thanks in advance
 

Attachments

  • Book1.xlsx
    14.4 KB · Views: 8
Sorry - the workbook attached will not open - it is reporting as invalid.
 
The attached the workbook is now opening.
 

Attachments

  • employee data.xlsx
    9.6 KB · Views: 7
yes i have posted here and other forums too. if i get the answer i ll post here in this forum so that others can benefit too. i have read the terms and conditions page.

Thanks for understanding
 
Here's a solution using Countif
 

Attachments

  • employee data countif.xlsx
    12.8 KB · Views: 7
that worked. thank u. u r great.

can i know some other value can be added after CL5?
FIRST QUESTION
after finishing CL5,can it go on with PL6,PL7,PL8,.....
SECOND QUESTION
after finishing CL5, can it go on with SL1,SL2,SL3....

thanks
 
Yes, see attached
 

Attachments

  • employee data countif2.xlsx
    13.8 KB · Views: 6
You must log in or register to reply here.
Back
Top