Thread: unique numbers
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default unique numbers

You can use a formula to produce the numbers

a1: 1
a2: =OFFSET(A2,-1,0)+1
drag fill A2 down the column

when you insert a row, select the first cell in the new row and do Ctrl+d to
copy down the formula

--
Regards,
Tom Ogilvy


"Peter" wrote in message
...
Hi,

I have a collumn with sequenced numbers. (1.2.3.4.5.6.7.8.9)
Each time a row is added i count the amount of numbers in the collumn +1.
Now, after they have been put in, there are some numbers replaced bij "x"
meaning the item does not exists anymore.
Now here's the problem:
When the "x" replaces a number i have two times the same number in the
collumn because the remaining numbers don't automaticly adjust to the lost
number. (1.2.3.4.x.6.7.8.9.9)
How do i solve this, so the numbers automaticly follow eachother up
(1.2.3.4.x.5.6.7.8.9.10...) after the "x" is set.

Hope you understand what i mean.

Regards,
Peter