Automatically renumbering in an excel cell

M

Madi

I have a list of about 300 items. How do I set the Numbers up so that if I delete something at the top of the list, the rest of the numbers automatically renumber?
 
H

Harald Staff

How about formula
=ROW()

--
HTH. Best wishes Harald
Followup to newsgroup only please

Madi said:
I have a list of about 300 items. How do I set the Numbers up so that if
Click to expand...
I delete something at the top of the list, the rest of the numbers
automatically renumber?
 
M

Madi

The problem is that I didn't start at Row one ( I started at A6). Also, I have at the top of each page a header that says Item Number and Value so this title is counted as one of the rows and it throws all of the numbers off. Each Page has a Page total so this is also counted as one of the rows and my biggest problem is that the list is about 20 pages long so i can't really drag and fill to the end because it is counting rows that have no items in them. I tried the following formula: =ROW()-ROW($A$6)+1, but i it counts the rows that do not have an item on them. This thing is driving me crazy. Any other suggestions

----- Harald Staff wrote: ----

How about formul
=ROW(

-
HTH. Best wishes Haral
Followup to newsgroup only pleas

Madi said:
I have a list of about 300 items. How do I set the Numbers up so that i
Click to expand...
I delete something at the top of the list, the rest of the number
automatically renumber
 
P

Paul Falla

another way is to have a calculation based on the first
number. Eg if your first number is say 2000 and is found
in cell A1,for the next number type into cell A2 =A1+1
where 1 is the number that you wish to increment by. this
would give a result in A2 of 2001. fill the function down
the spreadsheet, and that way you can have any start
number and deleted rows will not be affected by subsequent
deleted rows
 
Top