ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   shuffle table of numbers (https://www.excelbanter.com/excel-discussion-misc-queries/184059-shuffle-table-numbers.html)

WLRobi

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?

Bernd P

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