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

    Formulaes not geting auto refreshed

    Hi Hui, I did the same thing u said in the second step.I have ticked the autmatic check box and now it is working fine now. Thanks a lot.It was real urgent. thanks a lot.
  2. A

    Formulaes not geting auto refreshed

    When i am copying a formula to next cell it is just taking the same value as appearing in the first formula.i.e. it is not appyling the formula in next cell but when I open the formula with F2 and press enter then it updates the formula. Please help me to resolve this issue.
  3. A

    Using vlookup in case vlookup value is coming more than once in table array

    Hi All, I am facing a problem while applying vlookup. When we apply vlookup to a data then if in the table array (i.e. the column from which the data is to be vlookedd up) if lookup value is coming more than once then vlookup picks up the value of the first line item only.Is there a way where...
  4. A

    How to round off values

    Ya this formula helps. I Wasnt aware of it Thanks a lot for such a spontaneous reply It was very urgent Thanks
  5. A

    How to round off values

    How can i round off 8790 to multiple 0f 500 i.e it gets round off to 9000 or 8500. i have tried round off formula it is not working please help Thanks
  6. A

    How to go to different sheets(to see the value) from a cell containing formula

    If in a cell i have applied a formlua of sum form two differnnt sheets of the same file then by pressing Ctrl & [ I get to see the first value only but if after seeing the first value i want to go to second value directly then how i can go to it. Thanks in advance Please revert
  7. A

    Error while saving file

    when i am saving my excel file it shows an error saying -"errors were detected while saving file & file can be saved by repairing or removing some feature.To make repairs in new file click continue" and then after that when i click continue then a diaglogue box shows some log of liosting...
  8. A

    Not able to add more rows between two rows.

    Thanks a lot.Its done now.The link provided the solution-Ctrl+6. Thanks
  9. A

    Not able to add more rows between two rows.

    Yes i have done that but still i am not able to add rows.
  10. A

    Not able to add more rows between two rows.

    I am not able to add more rows between two rows. I am trying CTRL+Shift+PLUS.but it says cannot shift object Please help i am a beginner.dnt knw much about excel
Back
Top