A few words of thanks would be greatly appreciated.

Excel - Create serial numbers


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.

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 Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Published by . Latest update on by aakai1056.

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 (https://ccm.net/).