I'm not sure if this is possible, but I would like to create an ordered numeric list automatically based on a cell value. For example, if I have a cell with a value of 100, I want excel to automatically generate a list from 1-100. If instead that cell has a value of 50, I want excel to automatically generate a list from 1-50, starting in the same cell as before. Is this possible?
I would use this to help graph density functions (beta and binomial). If there is an easier way besides generating all the values in one column and using the pdf formula in the other column, please let me know.