Shuffle Data using Dynamic Arrays


Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use Sortby and Randarray Dynamic Arrays to shuffle dataset in Microsoft Excel. Let’s get started.


Do watch the video below. Share, like, comment and subscribe

Sample Data

In the caption below, we have the sample data showing records for Order Date all through to Sales Amount

In columns C and D respectively, we can observe that Sales Executive and Payment Method were sorted from A to Z. Therefore, our goal is to shuffle the dataset into columns E and F respectively

Shuffle Data

To shuffle the dataset,

  • In cell E2, enter this formula: =SORTBY(C2:D100,RANDARRAY(ROW(C2:D100)))
  • Deploy CTRL + Enter

From the caption below, we can see that the dataset has been shuffled and the result spills to the cells below and the column to the right (column F). This is made possible because of Dynamic Arrays

See you in the next tutorial


Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *