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 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?