ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I number the cells when I am making a list? (https://www.excelbanter.com/excel-worksheet-functions/140217-how-do-i-number-cells-when-i-am-making-list.html)

Marybeth

How do I number the cells when I am making a list?
 
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.

William Horton

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.



All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com