In Excel, Re-arrange A Sequence N Times Randomly

Problem description & analysis:

Column A is a random sequence. Cell B2 contains the parameter that represents the number of times of re-arranging members of the sequence.

We need to rearrange column A N times.

Solution:

Use SPL XLL to enter the formula below:

=spl("=?2.conj(?1.sort(rand()))",A2:A5,B2)

As shown in the picture below:

Explanation:

"integer.()" represents looping N times. conj() function concatenates multiple sequences. sort(rand())sorts a sequence randomly.