Autonumber

  • Thread starter Thread starter NG_Leeds
  • Start date Start date
N

NG_Leeds

Does anyone know if it is possible to input an "auto number" in to
column where it will count the number of entries starting at 1 and the
increasing, so that any new entries either at the bottom or in th
middle of the existing alters the number accordingly?

Thank you very much for any assistanc
 
You can count the number of entries starting at, say, A2, with a formula like
this: =COUNTA(A2:A6000). Adjust references to quit.
 
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

Conditional Hiding of Rows or Columns 6
Require formula to search across multiple worksheets 2
Count function in Auto-Filtered data 1
Counting the number of entries in a column 7
counting entries 2
Formula to average last 25 entries in a column? 4
Duplicate Entries 3
Access Auto Matching Duplicates? 0

Back
Top