Sign in with
Sign up | Sign in
Your question

Auto number in excel cells

Last response: in Windows 7
Share
October 2, 2012 2:38:53 PM

Dear all, I have numbers e. g. 1 to 100 in excel in a particular column. If I remove any number e. g. 13 & keep that cell blank. Further cells should get automatically numbered from 13 onwards. Thanking all & hope to get answer.
a b $ Windows 7
October 2, 2012 2:50:55 PM

Hi,

So what I understand is that you start from cell 1 and put 1 in there,
in the 2nd cell it would be 2 (so you type the 1 number (1 and write "=A1+1") then copy to next cell.

once you get to number 13, erase it and in the next cell write "=A12+2"), then in next cell write the formula mention above.
This should give you what you want.

I can send you an example if you need one just write me a personal message
m
0
l
a b $ Windows 7
October 2, 2012 2:57:12 PM

Looks suspiciously like a homework assignment.

OP, post your code and we'll critique and give pointers but we will not do your homework for you.
m
0
l
a b $ Windows 7
October 2, 2012 4:38:05 PM

sounds to me like you want to insert a cell at A13 and push cells down, it would look just like deletion and the numbers continuing but it would be done by a different way.
m
0
l
!