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
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