View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
William Horton William Horton is offline
external usenet poster
 
Posts: 96
Default How do I number the cells when I am making a list?

In the column next to the column you are entering the names you could put the
formula...

=ROW()-X (where X is 1 minus the row # of where your list starts). Example
if you begin your list in row 20 you would put the formula =ROW()-19. That
way your list would start with 1 (20 - 19).

Hope that helps.

"Marybeth" wrote:

I am needing to number a list of names that I am typing, so that I know how
many I have. However, I have been unsuccessful in finding how to number the
cells as I go. Does any one have any ideas? Thank you.