Copy contents from one cell to another

[Don]

Is there some Function that will move the contents of one cell to another?
I want to copy data from a static cell to another cell based on the value in
the contents of another cell.

For instance, I have a list of names in Alphabetical order in column 'A'.

I have a list of whole numbers from 1 to 50 in column 'B'. The numbers in
column 'B' will change order randomly when I recalculate (F9). I want to
use this number to reference the cell in column 'A' and copy that name to
column 'C', starting at 1 and work thru 50, thus jumbling the names.

If the 1st number in column 'B' is 20, I would take the 20th name in column
'A' and copy it to the first cell in column 'C'. and so on down the line.

Any help I could get, I would appreciate - Thanks.

Don D.

 

[RagDyeR]

Try this in C1:

=INDEX(A$1:A$50,RANK(B1,B$1:B$50))

And copy down to C50.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Is there some Function that will move the contents of one cell to another?
I want to copy data from a static cell to another cell based on the value in
the contents of another cell.

For instance, I have a list of names in Alphabetical order in column 'A'.

I have a list of whole numbers from 1 to 50 in column 'B'. The numbers in
column 'B' will change order randomly when I recalculate (F9). I want to
use this number to reference the cell in column 'A' and copy that name to
column 'C', starting at 1 and work thru 50, thus jumbling the names.

If the 1st number in column 'B' is 20, I would take the 20th name in column
'A' and copy it to the first cell in column 'C'. and so on down the line.

Any help I could get, I would appreciate - Thanks.

Don D.

 

[Don]

RD, That worked perfect. Thank you very much. I was away from
spreadsheets for quite a while and all I used in the past was QP. I'm
starting to get back a little feel for it now. I appreciate the help.

Don D