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

    Excel refresh

    How does Excel refresh a sheet -- down then across, or across and down?
  2. J

    Option buttons

    can I use these??
  3. J

    Option buttons

    For VBA buttons, one is called an "Option Button"
  4. J

    Option buttons

    How do you change the "size" of an Option Button -- it shows too small
  5. J

    Generating values from a normal distribution

    Hui -- thanks for the updated information -- guess I will have to get the new version of Excel!!
  6. J

    Generating values from a normal distribution

    I wish to generate random picks from a normal distribution. I can use the norminv(rand(), mean, standard dev) function yet I have read there are some problems with the Excel random number generator. If so, how do you get around this?
  7. J

    Sorting A-Z in an 1-column array which has variable members

    Chandoo -- I have a 1-column array which can have anywhere between 25 - 100 words (text). I would like to write a macro to sort this array from A-Z. The problem is if you sort the entire 100 cell array (assuming the words were not put in a-Z order) and there is only 25 words, you get 75 spaces...
Back
Top