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

    shared workbook very slow

    Hey all, i have a shared workbook used across 8-10 computers, running a lot of vba and forumlas. it ends up running terribly slow after a while and i have to unshare and reshare it for it to speed up. Is there any good practice tips to avoid this situation in shared workbooks? some kind of...
  2. R

    Help with index(small(if

    Awesome, thank you so much.
  3. R

    Percentage

    Shivapavan, You could just write your own function. To do this open the VBA editor (alt+f11) and go to insert -> module. Then paste the following: Function percentage(amount As Integer, perc As Integer) percentage = (amount * perc) / 100 End Function Then while in excel you can do...
  4. R

    Help with index(small(if

    I am trying to duplicate all rows where column u shows "december" and i am trying to use this formula to return the data in row b where column u = december: sheet 1 a1 is just a helper cell containing the word december...
Back
Top