Create Column by giving input limits with increasing increments ???

[saaadi1616]

Hi all,

I am a new user in the forum. I am having trouble which I hope could get sorted out from this forum.

I need Excel to make a column with first and last cell values taken from specific cells and increasing with a certain user defined increment.

For example, In the first sheet when I input my flowrate range e.g. (from 10 to 50), I get a column on the same or different sheet with values starting from 10 and stopping at 50 ( with an incremental increase of 1). So that everytime I change my range in the input cells in the first sheet, my values in the desired column get changed accordingly. This will be of enormous help. Thanks alot

Nice day.

[Glenn Kennedy]

Something like this, maybe (in E2, copied down):

=IF($A$2+$C$2*(ROWS(E$2:E2)-1)>$B$2,"",$A$2+$C$2*(ROWS(E$2:E2)-1))

with start in A2, end in B2 and increment in C2

[saaadi1616]

Great Glenn. This is exactly what I was looking for. Cheers mate !!!

[Glenn Kennedy]

You're welcome.