assigning serial numbers

  1. C

    Serial Number on filled rows

    HI Team, Need help creating a macro in plotting serial numbers in excel in column A which has some blank rows. Cell A9 is the first row from which the numbering starts so my cell A9 value is “1” After that there are some blank rows that are not fixed and some rows have numbers. I need a macro...
  2. P

    Assigning serial numbers to non adjacent or non contiguous cells

    Is there any technique in Excel to assign serial numbers to non adjacent or non contiguous cells in Excel. For Example in cell A1 I want to assign 1, then after 2 rows in cell A4 I want to assign 2, then in A7 I want to assign 3, and so on with the rest cells in Column A ?
    • pbansl
    • Thread
    • assigning serial numbers non adjacent cells
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top