auto numbering


November 3rd, 2012 by nisar 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 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.

Leave a Reply

You must be logged in to post a comment.

s2Member®