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.
If Function: [ Ссылка ]
IsEven Function: [ Ссылка ]
IsOdd Function: [ Ссылка ]
Row Function: [ Ссылка ]
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:
Advance Excel Tutorial: [ Ссылка ]
Excel Tutorial for Beginners: [ Ссылка ]
Excel Case: [ Ссылка ]
Combine Workbook & Worksheets: [ Ссылка ]
All About Comments in Excel: [ Ссылка ]
Excel VBA Programming Course: [ Ссылка ]

Social media:
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
Blogger: [ Ссылка ]
Tumblr: [ Ссылка ]
Instagram: [ Ссылка ]
Hubpages: [ Ссылка ]
Quora: [ Ссылка ]

свернуть