Automatically move names when numbers are put in sheet

Pinewood · Mar 7th, 2002, 10:07 PM

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 · Mar 7th, 2002, 10:11 PM

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.

Mar 7th, 2002, 10:11 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 10:07 PM	#1
Pinewood New Member Join Date: Mar 2002 Location: Wisconsin Posts: 1	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,