How to Select a Random Value From a List in Google Sheets

To select a random value from a list in Google Sheets, follow the steps below:

  1. Open your Google Sheet containing the list of values.
  2. In an empty cell, type the following formula:

Replace A1:A10 with the range of cells containing your list. This formula will return a random value from the list.

Note: The RANDBETWEEN function will recalculate and change the value every time there's an edit in the sheet. If you want to keep the random value constant, copy the cell and paste it as a value (Ctrl+Shift+V or right-click and choose "Paste special" > "Paste values only").


Let's assume you have a list of fruits in cells A1 to A6 as follows:

A1: Apple
A2: Banana
A3: Orange
A4: Grapes
A5: Mango
A6: Pineapple

To select a random fruit from this list, you can use the following formula in an empty cell:


This will return a random fruit from the list in cells A1 to A6.

Did you find this useful?