shuffling numbers in a column

[guitarman]

Hi

I was just wondering if there is a formula for shuffling numbers in a column so I can do the August medal event to stop the moaners. Example

A

1

2

3

4

5

6

7

8

Shuffle them so you have somehing like. Example

A

7

2

6

4

1

5

8

3

I don't know if it can be done but it would be very useful if it can many thanks

Mike

 

[Busymanjohn]

Hi guitarman ,, need more info ,, what is driving the reshuffle ?

 

[NARAYANK991]

Hi Mike ,


Can you check out this post ? I've mentioned one way of doing this :


http://chandoo.org/forums/topic/rand


Narayan

 

[Jai9]

Hi,

Try this. This uses a helper column

I have numbers 1 to 10 in A29 to A38.

I have =rand() in B29:B38.( Helper column )

In C29

=OFFSET($A$29,MATCH(LARGE($B$29:$B$38,ROW(A1)),$B$29:$B$38,0)-1,0)

and copy down.

Every time you recalculate the sheet, order changes.


Jai

 

[guitarman]

Hi Jai9

Thank you very much that works a treat and also all you other guys Busymanjohn and my old friend NARAYANK991 much appreciated all have a great day and a brilliant life

Mike