In Excel, Re-arrange A Sequence N Times Randomly

This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

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.

This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

Print Share Comment Cite Upload Translate Updates

APA

Judith-Excel-Sharing | Sciencx (2024-06-26T05:52:14+00:00) In Excel, Re-arrange A Sequence N Times Randomly. Retrieved from https://www.scien.cx/2024/06/26/in-excel-re-arrange-a-sequence-n-times-randomly/

MLA

" » In Excel, Re-arrange A Sequence N Times Randomly." Judith-Excel-Sharing | Sciencx - Wednesday June 26, 2024, https://www.scien.cx/2024/06/26/in-excel-re-arrange-a-sequence-n-times-randomly/

HARVARD

Judith-Excel-Sharing | Sciencx Wednesday June 26, 2024 » In Excel, Re-arrange A Sequence N Times Randomly., viewed ,<https://www.scien.cx/2024/06/26/in-excel-re-arrange-a-sequence-n-times-randomly/>

VANCOUVER

Judith-Excel-Sharing | Sciencx - » In Excel, Re-arrange A Sequence N Times Randomly. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/06/26/in-excel-re-arrange-a-sequence-n-times-randomly/

CHICAGO

" » In Excel, Re-arrange A Sequence N Times Randomly." Judith-Excel-Sharing | Sciencx - Accessed . https://www.scien.cx/2024/06/26/in-excel-re-arrange-a-sequence-n-times-randomly/

IEEE

" » In Excel, Re-arrange A Sequence N Times Randomly." Judith-Excel-Sharing | Sciencx [Online]. Available: https://www.scien.cx/2024/06/26/in-excel-re-arrange-a-sequence-n-times-randomly/. [Accessed: ]

rf:citation

» In Excel, Re-arrange A Sequence N Times Randomly | Judith-Excel-Sharing | Sciencx | https://www.scien.cx/2024/06/26/in-excel-re-arrange-a-sequence-n-times-randomly/ |

Please log in to upload a file.

There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.