Excel_Automatic numbering of rows

  swapper 14:01 13 Dec 05
Locked

In column two of excel, I would like to set up an automatic six digit numbering sequence, so that I can give the contents of each each row a unique number(identity), automatically, apart from the numbers in column one.
I want that number (I.D.)to stay with the content of that row, even when I delete or add further rows.
Any advice please?

  johnnyrocker 14:11 13 Dec 05

click here might help


johnny.

  VoG II 18:25 13 Dec 05

ASAPUtilities click here

On the ASAP menu, Fill > Quick numbering of cells or Random numbering of cells. click here

  csqwared 21:09 13 Dec 05

Try...

in Column 2 =Row(Cell ref in column1)

  swapper 07:17 14 Dec 05

Thanks everyone, johnnyrocker gave me a good link, thanks for the others also:-))

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…