• 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

    Locking Cells with Formula in Dynamic Table

    Hello, I wonder if someone could help me solve this problem. I converted my data into a dynamic table with table options. I tried to protect my worksheet with 'protect worksheet' with the objective to hide and protect formulas. I first selected all the worksheet and in format I unticked...
  2. N

    Locking Cells with Formula in Dynamic Table

    Hi Friends, I have a Dynamic table created with formula in it, for few of the columns, but I need to lock them since the user may tend to medle with formula, Hence these needs to be locked, but the table should be extended with formula, for a new entry Please help Thanks in advance, Nagesh
  3. N

    Want to retrive the months between the input values?????

    Hi Suman, check the undisclosed function by MS, =datedif(1-1-12,1-12-12,"m") also the Output is in Number format & not is date format Try and let us know your feedback
  4. N

    Conditional formatting in Pivot

    Hi Chandoo, First of all thanks for this Portal & Forum, Day by Day there are new innovations with old formulas, which is in-exhaustive, Thanks for all the fellow-researchers & contributors, I have a strange question, Can we have a conditional formatting in Pivot ? for example -...
Back
Top