**Excel** can help you shuffle or randomize different formats of data quickly in easy ways. You can shuffle data within one column as well as around different columns. In this article, we will show you how to shuffle numbers in Excel in 7 easy methods.

**Table of Contents**hide

## Download Practice Workbook

Download this practice workbook for practice while you are reading this article.

## 7 Effective Ways to Shuffle Numbers in Excel

In this article, we will demonstrate how to shuffle numbers in **Excel** in 7 effective ways. We will use the following dataset for this purpose.

### 1. Insert RAND Function

This is one of the easiest methods to shuffle data in Excel. Follow these steps to learn how to use **the RAND function** to shuffle numbers.

**Steps:**

- First of all, insert a column of
**Random Numbers**and type the following formula.

`=RAND()`

**RAND()**returns any evenly distributed random real number greater than or equal to 0 and less than 1.

- Next, press
**Enter**to get the random number in cell**D5**.

- Now,
**double-click**at the bottom right corner of cell**D5**to copy the formula to all cells.

- Once you get the random numbers in the whole column,
**select**all the random numbers and go to the**DATA**tab.

- Then select either
**Sort Smallest to Largest**or**Sort Largest to Smallest**from the**Sort & Filter**settings.

- Once you select one of the two options, a pop-up box will appear.
- Click on
**Expand the selection**and press**Sort**.

- The
**List of Food**and**Quantity Sold**will be shuffled.

### 2. Apply RANDBETWEEN Function

We will use **the RANDBETWEEN function** to shuffle numbers in columns now. The steps are discussed below.

**Steps:**

- First, insert a column of
**Random Numbers,**and then write down the following formula in cell**D5**.

`=RANDBETWEEN(1,100)`

**RANDBETWEEN**function returns random integer numbers between a specified range.**(1,100)**refers to the range. Selecting a smaller range can return the same value for more than one cell. The larger the range, the lower the chance of repetition. Therefore, choose a large range to avoid repetition.

- Now, press
**Enter**to get a random value between 1 to 100 in cell**D5**.

- Next, move your cursor to the
**bottom right corner**of cell**D5**and**click twice**. - All cells will be filled with random numbers between 1 to 100.

- Now, select all the random numbers and press
**Alt+A+SA**to sort the values from smallest to largest. - A pop-up window will show up. Just select
**Expand the selection**and click on**Sort**.

- All the data of columns
**B**and**C**will be randomized and you will get your desired results.

### 3. Combine SORTBY and RANDARRAY Functions

In this method, we will shuffle numbers in **Excel** by combining **the SORTBY function** and **the RANDARRAY function**. Keep on reading to learn how to do it.

**Steps:**

- Initially, insert a new column (
**Random Numbers**) to generate random numbers. - Then type the following formula in cell
**D5**.

`=RANDARRAY(8,1)`

**RANDARRAY**returns an array of random numbers.**“8”**refers to the number of rows with data and**“1”**refers to the number of columns.

- Hit the
**Enter**button and then**double-click**the**bottom right corner**of cell**D5**.

- Now we want to shuffle the numbers in the
**Quantity Sold**To do that, write down the formula given below.

`=SORTBY(C5:C12,D5#)`

**SORTBY**sorts the contents of a range or array based on the values in a corresponding range or array.**C5:C12**refers to cells**C5**through**C12**.**D5#**refers to the random values of column**D**based on which the sorting will be done.

- Press the
**Enter**button. - To copy the formula to all the cells,
**click two times**at the**bottom right corner**of cell**E5**. - Thus you will get the shuffled numbers.

### 4. Run a VBA Code

Now we will run a **VBA** code to shuffle data in **Excel**. The VBA code given in this method can shuffle data from one column to another. We will show you how you can apply this **VBA** code in your **Excel**.

**Steps:**

- First,
**select**all the data you want to shuffle.

- Next, press
**Alt+F11 to**open**Microsoft Visual Basic**window.

- Then click on the
**Insert**tab in that window and select**Module**.

- A module to write codes will open. Copy the following VBA code in the module.

```
Sub Shuffle()
Dim range As range
Set range = Selection
Dim Row As Long
Dim Column As Long
Row = range.Columns.Count
Column = range.Rows.Count
Dim i As Long
Dim j As Long
For i = Column To 1 Step -1
For j = Row To 1 Step -1
Dim rndRow As Long
Dim rndColumn As Long
rndRow = Application.WorksheetFunction.RoundDown(Column * Rnd + 1, 0)
rndColumn = Application.WorksheetFunction.RoundDown(Row * Rnd + 1, 0)
Dim temp As String
Dim tempColor As Long
Dim tempFontColor As Long
temp = range.Cells(i, j).Formula
tempColor = range.Cells(i, j).Interior.Color
tempFontColor = range.Cells(i, j).Font.Color
range.Cells(i, j).Formula = range.Cells(rndRow, rndColumn).Formula
range.Cells(i, j).Interior.Color = range.Cells(rndRow, rndColumn).Interior.Color
range.Cells(i, j).Font.Color = range.Cells(rndRow, rndColumn).Font.Color
range.Cells(rndRow, rndColumn).Formula = temp
range.Cells(rndRow, rndColumn).Interior.Color = tempColor
range.Cells(rndRow, rndColumn).Font.Color = tempFontColor
Next j
Next i
End Sub
```

- Now press
**F5**to**run**the code. - Go back to the worksheet and you will find all that all the data are shuffled.

### 5. Combine VLOOKUP and RANDBETWEEN Functions

In this method, we will combine **the VLOOKUP function** and** the RANDBETWEEN function **to shuffle numbers in Excel. Read the following steps to do it.

**Steps:**

- First of all, insert a column named
**Random Numbers**and type the following formula to generate random numbers.

`=RANDBETWEEN(1,8)`

**(1,8)**refers to any number between 1 to 8 that the**RANDBETWEEN**function will return.

- Hit
**Enter**and**double-click**the**bottom right corner**of cell**D5**to copy the formula to all the cells.

- Now to get the shuffled value of column
**C**, type the following formula in cell**E5**.

`=VLOOKUP(D5,B$5:C$12,2,FALSE)`

- D5 refers to the first value of the random numbers.
**B$5:C$12**is an absolute reference to the cells**B5**through**C12**.**FALSE**refers to the exact match.

- Press
**Enter**. - Now copy the formula to all the cells by
**clicking twice**at the**bottom right corner**of cell**E5**and there you have your shuffled quantity.

### 6. Merge CHOOSE and RANDBETWEEN Functions

In this part of the article, we will shuffle numbers in Excel by merging **the CHOOSE function **and **the RANDBETWEEN function**.

**Steps:**

- First, insert a new column (
**Shuffled Quantity**) and write down the following formula in cell**D5**.

`=CHOOSE(RANDBETWEEN(1,8), $C$5, $C$6,$C$7, $C$8, $C$9, $C$10, $C$11, $C$12)`

**$C$5, $C$6,$C$7, $C$8, $C$9, $C$10, $C$11, $C$12**refers to the values of**C5**to**C12**.

**Formula Breakdown**

● **RANDBETWEEN(1,8)** returns random integer numbers between **1** to **8**.

● **CHOOSE(RANDBETWEEN(1,8), $C$5, $C$6,$C$7, $C$8, $C$9, $C$10, $C$11, $C$12)** looks into the random number given by **RANDBETWEEN** and returns any of the cell value from **C5** to **C12**.

- Hit
**Enter**on your keyboard and**left-click**the**bottom right corner**of cell**D5**twice. - You will find the desired results in
**D**column.

### 7. Merge INDEX and RANDBETWEEN Functions

Before conclusion, we will see one last method to shuffle numbers in Excel. We will use **the INDEX function** and **the RANDBETWEEN function** for this purpose. The procedure is discussed below:

**Steps:**

- First of all, write down the formula given below in your desired cell.

`=INDEX($C$5:$C$12,RANDBETWEEN(1,8))`

**$C$5:$C$12**refers to the cells from**C5**to**C12**.

**Formula Breakdown**

● **RANDBETWEEN(1,8)** returns random integer numbers between **1** to **8**.

●** INDEX($C$5:$C$12,RANDBETWEEN(1,8))** returns a value from the range **C5** to **C12** after looking into the random number given by **RANDBETWEEN**.

- Hit
**Enter**and copy the formula by double-clicking the bottom right corner of cell D5 to get the desired results.

## Things to Remember

- If you want to shuffle values around different columns, use the
**VBA**code. Other methods shuffle values within the same column only. - Don’t forget to give proper cell references or you won’t get the desired results.
- Input a large range in the
**RANDBETWEEN**function to avoid repetition of the same numbers.

## Concluding Remarks

Thanks for making it this far. I hope you find this article useful. Now you know 7 different methods to shuffle numbers in **Excel**. Please let us know if you have any further queries and feel free to give us any recommendations in the comment section below.