Excel_Automatic numbering of rows

  swapper 14:01 13 Dec 05

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


  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


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.

Hands-on: Samsung Galaxy S8 review

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

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos