Excel_Automatic numbering of rows

  swapper 14:01 13 Dec 2005
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 2005

click here might help


johnny.

  VoG II 18:25 13 Dec 2005

ASAPUtilities click here

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

  csqwared 21:09 13 Dec 2005

Try...

in Column 2 =Row(Cell ref in column1)

  swapper 07:17 14 Dec 2005

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

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

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?