1-100

[schaduw - ExcelForums.com]

Is it possible to have row A numbered from 1 to 100, and if one of th
numbers is removed the count will automatically change

i.e




etc

Now 2 gets deleted, how can i get excel to change 3 to 2 and so on fo
the rest of the numbers

hope this makes sense at all :

 

[Frank Kabel]

Hi
in A1 enter
=IF(B1<>"",1,"")

in A2 enter
=IF(B2<>"",MAX($A$1:OFFSET(A2,-1,0))+1,"")
and copy this formula down for as many rows as required. Now everytime
someone enters data in column B column A shows a ID value

 

[Trevor Shuttleworth]

=ROW() in cell A1 and copy down

Regards

Trevor