How To Number Every Other Row in Excel

How To Number Every Other Row in Excel
In this excel tutorial, I’ll demonstrate a tremendous way to automatically number every other row in excel. Here the idea is to insert sequential serial number but keep one row empty after each serial number.
This is verry important if you are doing journal in excel. In accounting concept, you need to enter two rows for one transaction, one will be Debit and the other one will be Credit. But the serial umber will be same. So, we insert number in the first cell and add debit amount and the next row we use to insert credit amount. This is where you’ll need sequential numbering on every other row.
Without further ado let’s follow the instruction below to sequentially number every other row in Excel.
I’ll be using formula in this situation. But there could be two scenarios here. If you have no header and you need to start numbering the first cell then you need to use the following formula
=IF(ISEVEN(ROW()),"",(ROW()+1)/2)

Now lets assume you have a header in row 1 and you need to start counting from row 2 then you need to use the below formula.
=IF(ISODD(ROW()),"",(ROW())/2)

Here are the functions I’ve used in this formula. Check the link below to learn them properly.
So, this is how you sequentially number every other row in excel automatically using formula.
#SerialNumber #Row

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[natashaholmes]

This was very informative! Is there a resource where I can find the formulas for excel?

[amnghn]

Thank you soooo much. this was very useful