shuffle table of numbers

[WLRobi]

I have a table of numbers that I would like to shuffle around into a random
order. Does anyone know how to do this?

 

[Bernd P]

Hello,

Array-enter into 10 adjacent vertical cells
=INDEX(A1:A10,uniqrandint(10))

or array-enter into 10 adjacent horizontal cells
=INDEX(A13:J13,1,uniqrandint(10))

for example.

My UDF UniqRandInt you will find here:
http://www.sulprobil.com/html/uniqrandint.html

Regards,
Bernd