In this article:

How to Randomize a List in Google Sheets (Easiest Way in 2024)

Can You Randomize a List in Google Sheets?

You can randomize a list in Google Sheets using different methods such as the Randomize range feature, filter and sort feature and using a formula. We will explore in more detail how to do each method in the next sections. 

How to Randomize a List in Google Sheets Using the Randomize Range Feature

Follow the process below to randomize a list in Google Sheets. 

1. Open the Target Google Sheets

Open the Google Sheets containing the list you want to randomize.

how to randomize a list in google sheets

2. Highlight the Entire List for Randomization

Select the full range of the list you aim to shuffle.

randomize list in google sheets

3. Activate the "Randomize range" Option via Right-Click Menu

Right-click within the selected range and choose "Randomize range" from the context menu.

how to randomize list in google sheets

4. Confirm the List Has Been Randomized

Verify the list's order has been shuffled immediately, indicating successful randomization.

randomize a list in google sheets

How to Randomize a List in Google Sheets Using a Formula

Follow the steps below to randomize a list in Google Sheets using a formula. 

1. Access the Google Sheets with Your List

Navigate to the specific sheet that holds the list you want to randomize.

can you randomize a list in google sheets

2. Append a RAND Formula Adjacent to Each List Item

Next to the first item of your list, in a new column, input =RAND(). Drag the fill handle down to apply this formula next to each list item.

3. Employ the SORT Function to Randomize Based on RAND Values

In a new column, type =SORT(A1:B10, 2, TRUE), adjusting A1:B10 to include your original list and the RAND() values.

This will sort your list by the random numbers, randomizing the order.

4. Stabilize the Randomized List by Pasting as Values

To finalize your list in its randomized order, copy it and then paste using "Paste special" > "Values only."

How to Randomize a List in Google Sheets Using the Filter and Sort Feature 

1. Ready Your Data in Google Sheets

Enter names in Column A and corresponding groups in Column B of your sheet.

2. Isolate the "Red" Group with the FILTER Function

Prepare to randomize only the "Red" group members by setting up a FILTER within your SORT function for targeted randomization.

3. Combine FILTER, SORT, and RANDARRAY to Randomize the "Red" Group

Use =SORT(FILTER(A1:A10, B1:B10="Red"), RANDARRAY(COUNTA(FILTER(A1:A10, B1:B10="Red"))), TRUE) in an empty cell to filter, then randomize the "Red" group names.

4. Execute the Randomization Formula

Input the formula in a designated cell, press Enter, and observe the "Red" group names displayed in a new, randomized order.

We hope that you now have a better understanding of how to randomize a list in Google Sheets. If you enjoyed this article, you might also like our article on how to append in Google Sheets or our article on how to set up Google Sheets smart fill.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started