• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Replace a value with different name

vinoth.s1

New Member
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
vinoth.s1
You should reread
Seems that You have already forget some basic rules.
 
I have attached the work book which is opening now. Yes i have done in other forum before coming here. I have read the site rules now which i understood. If i come to know the answer will post here so that others can also be benefited.

Thanks for your time and making me understand
 

Attachments

  • employee data.xlsx
    9.6 KB · Views: 4
vinoth.s1
Please find this is working or not.
Hi S. Das,

Please refer to your answer, the helper column is not required.

Here's my formula solution using IF+COUNTIF function only.

In D12, formula copied across and down :

=IF(D6<>"L",D6,IF(COUNTIF($D6:D6,"L")<6,"PL"&COUNTIF($D6:D6,"L"),"CL"&COUNTIF($D6:D6,"L")-5))

69131
 
Last edited:
Thanks bosco_yip. I missed this point. You are awesome as always.
But still, there is a drawback in my formula as well as your formula. Both formulas working without checking the employee name, just referring to the cell. How could this drawback be overcome?
 
Back
Top