How to Create a Unique List of Values Across Multiple Columns in Google Sheets

Last Updated on April 15, 2023 by Jake Sheridan

In this tutorial, you will learn how to create a unique list of values across multiple columns in Google Sheets.

How to Create a Unique List of Values Across Multiple Columns in Google Sheets

When working with spreadsheets, you may find yourself needing to create a unique list of values from multiple columns. For example, you may have a range of numbers and you want to output a list of all unique values in that range.

In this guide, we will show you how to use a combination of functions to quickly create a unique list of values across multiple columns in Google Sheets.

How to Find All Unique Values in a Range in Google Sheets

Here’s how to find all unique values in a range in Google Sheets.

Step 1

First, we’ll use the UNIQUE function to return a list of unique values for each column in a range.

Do note that numbers can still repeat across columns using this method.

Step 2

If you want to create a unique list from a range of values, we’ll need to first use the FLATTEN function.

The FLATTEN function converts all values from a given range into a single column.

In the example above, we were able to place all the values in the range A1:D4 into a single column in column F.

Step 3

Next, we’ll use the UNIQUE function to find the unique values from the single column returned by our FLATTEN function.

Using both FLATTEN and UNIQUE, we’re able to return all unique values in a given range.

Summary

This guide should be everything you need to create a unique list of values across multiple columns in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.