Autogenerate serial number according cell reference Number ????

[krunal123]

Autogenerate serial number according cell reference Number ????

I have try cell Reference :

A2 =11

i try cell reference A2 to B3 , problem is B3 Cell value According Auto generate serial Number.

 

[Special-K99]

Maybe this?

in B3
=A2+ROWS(INDIRECT("1:"&ROW(A1:A100)))-1
and copy down the column