A few words of thanks would be greatly appreciated.

Excel - Create serial numbers

Microsoft's office software Excel is a powerful tool to perform day-to-day activities with, like simple arithmetic, sorting, filtering, arranging and summarising data in various formats. Excel has a huge collection of formulas which can be used independently or in conjunction with each other to achieve desired results, like creating serial numbers. Logical formulas can be combined with text or numeric functions to segregate data in any desired way, for example, to exclude rows which do not have serial numbers. The same formula can be applied to multiple cells by simply dragging it to them, or by using paste-special with formulas and number formats.


I have an Excel spreadsheet with information I want to catalogue. I would like to create a serial number for each entry. Certain rows are blank, however, and the function would need to ignore the blank rows.


  • 1. You want series to appear in Column A
  • 2. If a row has a data, then column B of that row would have data
  • 3. Row 1 is a header

Write in Cell A2


Drag this formula down


Thanks to rizvisa1 for this tip on the forum.

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.


This document, titled « Excel - Create serial numbers », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).