Automatically move names when numbers are put in sheet

[Pinewood]

I have in one column names, and when registration takes place, I assign these names numbers, based on when these listed people register.

It looks like this:
Car # Scout
Scout1
Scout2
Scout3
Scout4
Scout5

Example:
Scout5 registers first, and is assigned number 1, Scout4 registers next, and is assigned number 2, Scout2--number3,Scout1--number4, and Scout3--number5

I would like to be able to place the numbers in front of the names, and then have these numbers automatically sort, taking the names assigned to them, to end up like this:

Car # Scout
1 Scout5
2 Scout4
3 Scout2
4 Scout1
5 Scout3

What is the most convenient way to do this?
Thanks,

 

[Anne Troy]

Put your scout names in column B when the time comes.

In the cells of column a (starting row 2), put a 1 in cell A2. In cell A3 and then copied down, put:

=if(isblank(b3),"",a2+1) It gives you an *autonumber* type of thing.