Let’s see how to shuffle the records of a dataset using the RAND, LARGE, ROWS and VLOOKUP functions in Excel.
![](https://xlncad.com/wp-content/uploads/2022/03/Shuffle-Records.gif)
Step 1:
Insert a column on the left side of the dataset and generate an array of random numbers in it. The RAND Function in Excel can be used for this purpose.
=RAND()
![](https://xlncad.com/wp-content/uploads/2022/03/Shuffle-Records-1.png)
Step 2:
These random numbers are then sorted in their descending order using the LARGE and ROWS function.
=LARGE($B$3:$B$17,ROWS($B$3:B3))
![](https://xlncad.com/wp-content/uploads/2022/03/Shuffle-Records-2-1024x431.png)
Step 3:
The sorted values are then used inside the VLOOKUP function to extract the records against them.
=VLOOKUP(F3,$B$3:$D$17,2,FALSE)
![](https://xlncad.com/wp-content/uploads/2022/03/Shuffle-Records-3-1024x424.png)
And every time when we recalculate the sheet (Press F9) a new set of random numbers are generated and the records are rearranged.
![](https://xlncad.com/wp-content/uploads/2022/03/Shuffle-Records-4-1024x426.png)