![]() |
shuffle table of numbers
I have a table of numbers that I would like to shuffle around into a random
order. Does anyone know how to do this? |
shuffle table of numbers
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 he http://www.sulprobil.com/html/uniqrandint.html Regards, Bernd |
All times are GMT +1. The time now is 08:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com