fx =UNIQUE(A1:A100)ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

UNIQUE Formula for Statistical

Return unique values from a range. Copy-paste ready for Excel, Google Sheets, and Airtable.

=UNIQUE(A1:A100)
When you need this: When you have customer cities repeated (New York, Boston, New York, etc. in A1:A100) and need a clean list of unique cities.

How it works

  1. 1The UNIQUE function extracts all distinct values from the range (A1:A100).
  2. 2Removes duplicates automatically.
  3. 3Returns results in a new column, maintains original order.

Variations

UNIQUE ignoring empty cells
=FILTER(UNIQUE(A1:A100),UNIQUE(A1:A100)<>"")
UNIQUE with multiple columns
=UNIQUE(A1:B100,FALSE)

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIF — Count cells that meet a conditionStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatistical

Need a formula that's not here?

Generate custom formula →