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

Search results

  1. N

    Separate Name's Id

    is there any solution for removing extra spaces
  2. N

    Separate Name's Id

    Thanks Hui I did, but not working properly,there so many space in the cell, I tried clean, trim First Name Middle Name & Last name formula. So pls give any other solution for joining these names & id properly.
  3. N

    Separate Name's Id

    How do I split the name's & Id with extra spaces pls find link http://speedy.sh/k324D/Emp-Name-Id..xlsx Thanks
  4. N

    If(And

    I want write formula in cell B2 My requirement is In cell A2= 1,2,3 means "0-1 Day" if in cell A2=4 means "2 Days" in cell A2=5, "3 days" in cell A2= 6,7,8,9 comes means ">3 Days"
  5. N

    If(And

    Sorry I want use the if formula I tried with =IF(OR(A2=1,A2=2,A2=3),"0-1 Day",">3 Days") it is for 1 conditions & I "ll try to remaining 2 condition like =if(A2=4,"2 Days" & A2=5,"3 Days",">3 days" How to combained these 2 formula to get a result. Pls help me
  6. N

    If(And

    Pls find the link http://speedy.sh/4fbu7/Ageing-Slab.xlsx
  7. N

    If(And

    Hi =if(A2=1,"0-1 Day" A2=2,"0-1 Day" A2=3,"0-1 Day" A2=4,"2 Day" I have condition like below Ageing Slab 1 0-1 Day 2 0-1 Day 3 0-1 Day 4 2 Days 5 3 Days 6 > 3 Days 7 > 3 Days 8 > 3 Days 9 > 3 Days Pls help me. Thanks
  8. N

    Sum of 2 cells are equal to .................

    Thanks But I am not clear Please find the Link below http://speedy.sh/trTPv/Tgs-Vs-Ach.....xls
  9. N

    Sum of 2 cells are equal to .................

    Hi I have doubt please help me, Sum of 2 cells are equal to Grand Total of Pivot table which formula can I use
Back
Top