unique numbers

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

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
 
Maybe put 1 in A1, use a formula in A2 of

=MAX($A$1:A1)+1

and copy that down

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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
 
Hi,

Checked out both formula's.
Bob's formula workes best for me so i'm using that one.
Thanks to the both of you.

regards,
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top