How to assign index number

C

Charles Deng

I need to assign an index number to each record. These
index numbers should be in a new column. What can I do?
Thanks.


Charles Deng
 
J

Jason Morin

In the first row you could put:

=ROW()

and fill down. If first record is not in row 1, but say,
row 5, change it to:

=ROW()-4

Now copy the column and go to Edit > Paste Special >
Value.

HTH
Jason
Atlanta, GA
 
Top