I want to create an iteration in Excel by having the lower bound of 'x' increase by an increment until the upper bound of 'x' (E.g. Create a table from A1-A10 by starting the count from 0-10 with increments of 1).

How can I make it such that the table will self adjust its size with just the user prompting the upper-lower bounds of x and increment unit, so entering X_Lower=0, X_Upper=10 and X_increase=1 will give you a 2x10 table with column_1:iteration and Column_2:Result.

I am hoping to use this for iterative processes. Think of smoothing out CDF's & PDF's of probability distributions by increasing the the data points (i.e. decreasing the increments for more points)

Thanks.

1000474903