## auto numbering

November 3rd, 2012 by nisar

Dear,

I have a column in which I enter numbers e. g. 1 2 3 4 5 6 7 8 9 10 as on. Suppose if I remove /deleted any number e. g. 3, then further columns should automatically adjusted as 3 4 5 as on. PLEASE refer attached sheet, so you will get exact idea…what do I want. THANKING YOU.

5 Responses to “auto numbering”

1. Mansoor Sajid Says:

Insert starting number in Row two. Goto Row 3 and paste the following formula and then copy it all the way down.
Hope it works.

=IF(A2,A2+1,IF(A2=”",A1+1,”"))

2. Abedul Hoq Chowdhury Says:

Your B2 cell contains 1. You can enter formula =MAX(B\$2:B2)+1 in the cell B3 and copy it down to cell B389 as shown in your file. Please try and let me know.

3. nisar Says:

Salam Ailekum Bhaijan,

I tried & it worked.

Thanks a lot for valued help. Be in touch.

4. Mansoor Sajid Says:

Solution proposed by Mr. Abedul Hoq is more practical.

5. BenneTan Says:

hi there. you could also use:
=ROW()-1

=ROW() will give you the row number of that particular row. since you start in A2 & want that to be 1, i deduct 1 from it.