Hi,

Is there any formula to calculate auto numbering in next column based on the
value in the first column of any row.
For example, in the range of a1:a10, if the value is 1 in any row, then in
column B from the same row, it should auto fill numbers from 1 to 10
(increment by 1)

Please help me. This is so important for me.

Thanks in advance

Subbu