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

You can use the following formula to select a random value from a list in Google Sheets:

```=INDEX(A2:A16, RANDBETWEEN(1, COUNTA(A2:A16)))
```

This particular formula selects a random value from the range A2:A16.

The following example shows how to use this formula in practice.

Example: Select Random Value from List in Google Sheets

Suppose we have the following list of values in Google Sheets:

We can type the following formula into cell C2 to select a random value from the range A2:A16:

`=INDEX(A2:A16, RANDBETWEEN(1, COUNTA(A2:A16)))`

The following screenshot shows how to use this syntax in practice:

We can see that the formula randomly selected 26 from the list of values in column A.

If you click on cell C2 and click Ctrl+C, then click Ctrl+V to paste the same formula back into cell C2, a new value will be randomly selected from the list:

We can see that the formula randomly selected 33 from the list of values this time.

Note: You can find the complete documentation for the RANDBETWEEN function in Google Sheets here.

The following tutorials explain how to perform other common tasks in Google Sheets:

May 13, 2024
April 25, 2024
April 19, 2024
April 18, 2024

One Reply to “Google Sheets: How to Select a Random Value From a List”

1. Paul Harbour says:

Works great in Excel, but not in Google Sheets