How to assign index number

  • Thread starter Thread starter Charles Deng
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Outlook VBA- editing an empty value of a task item 0
MS Access Avoiding redundancy 1
Excel, assign cells in multiple worksheets from one sheet 1
Index/match across multiple columns? 19
INDEX 2
Find values across a row and return a text value from the same column 2
Merging multiple columns into one column (dynamically) 1
Index and match 2

Back
Top