Skip to main content
2 of 2
Improved formatting
marikamitsos
  • 13.1k
  • 4
  • 34
  • 59

Google Sheets formula for unique values across columns

I'm familiar with the UNIQUE function in Google Sheets and how it works on rows (see Examples 1 & 2 below).

Is there a function in Google Sheets that operates similarly on columns?

In Example 3 below, UNIQUE behaves as expected by treating this as a single unique row.

Examples 1,2

I've worked around this by using TRANSPOSE(UNIQUE(TRANSPOSE())) (see Example 4), however would like to know whether there's a built-in solution.

Examples 3,4

Robbie
  • 182
  • 10