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

    Randbetween

    I would like to be able to generate a random number that is between one range or another. For example, I would like to find a solution that would generate a number either between 1 and 100 or 200 and 300. Thank you in advance for your assistance.
  2. T

    Data Validation

    I need to create a data validation list that has the percentages 1 through 100 in increments of 1. I was wondering if there is anyway to do this without creating a range of 100 cells in the spreadsheet or typing the 100 numbers in the source box? Perhaps using the INDIRECT formula. Thank you in...
  3. T

    VLOOKUP

    I would like to create a VLOOKUP formula that is designed to look for an exact match in one column and find the appropriate value two columns to the right. However, if it doesn't find it, the formula then uses another lookup formula to search a different column for the same value and if it...
  4. T

    Formula Referring to value in a data validation cell

    I am attempting to construct a formula that refers to the value in a cell that is formatted with data validation and am not certain how to properly refer to the value. For example, if one of the values in the data validation is "core" and I want to add the values in a range based on whether or...
  5. T

    Bell Shaped Curve

    I was given a spreadsheet that provides the bell shaped allocations based on a number of periods. For example, if the number of periods is 8 then the distribution for each period is 5.00% 10.00% 15.00% 20.00% 20.00% 15.00% 10.00% 5.00%. if the number of periods is twelve then the distribution...
Back
Top