Need help to make a excel formula for number series.

[Raviijangra]

I want to create a list of numbers like 1 2 3 4 5 6 7 8 9 in one column eg A1 to A9. Problem is that like i delete A2 data then the sequence have to be like 1 in A1, 0 in A2 , 2 in A3 so on.
Can anyone make a formula so that i can drag it and when I delete one cell the the same value shifted to next cell.

For example
A1 1
A2 2
A3 3
If i delete A2 sequence have to be like
A1 1
A2 0
A3 2

 

[Peter_SSs]

Welcome to the MrExcel board!

i delete A2 data then the sequence have to be like 1 in A1, 0 in A2 , 2 in A3 so on.

If you delete A2 then there will be nothing in A2 so it cannot hold a zero.

 

[jasonb75]

Enter 1 in A2, then

=MAX(A$1:A1)+1

into A2 and fill down as needed.

Noting that in line with @Peter_SSs's post above, when you delete a cell it will be blank / empty.