Search results

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.

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

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

Thank you. That appears to be working properly. Greatly appreciated.

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

Thank you Hui. Greatly appreciated.

Thank you Hui for going above and beyond to answer my questions. Hope you don't mind if I ask just one more question. How would i generate the "your data" column with the information you have provided if I said to you that there were 15 steps instead of 8 or 12? To put this in context, the...

Thank you Hui for your response. Would you mind explaining your comment "adjusted to get 3%" and "adjusted to get 5%" as it relates to the standard deviation? Also, I'm not sure I understand how the data you generated is associated with the data I provided. For example if there were 15 steps...

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