Excel - Create serial numbers

October 2016


I have an Excel file that shows different values of schedule of correspondence and some of the mails are gone to different addresses and the mail ref. colum (showed only once). I want to count the mails serially. How to create exact serial numbers?

I want to skip the rows that have no values i.e. ref of the mails.

Example :

04/02/2010	C. Fox	Al-Futtaim Carillion	M. LEWIS 

04/02/2010	A. Simp	Al-Futtaim Carillion	I. AL-QUDAH 
04/02/2010	R. Pal	Al-Futtaim Carillion	A. Kumar 

Please provide a formula.


You Can Use ROW() function for generating serial numbers,
for example,

In A1 cell write:

=ROW() and press Enter,that will give 1 as answer.

Now click on A1(i.e. Select it)-> Press Ctrl+Shift+Down(to select the below fields which will get its serial now..) -> After selecting the column Goto--EDIT->FILL->DOWN

This will fill all the cells with the respective ROW number...

Thanks to Jyot Patel for this tip.

Related :

This document entitled « Excel - Create serial numbers  » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.