FormulaCraft

UNIQUE

UNIQUE outputs each value only once. Pair it with SORT or COUNTIF to build clean summaries and dropdown sources.

Excel
=UNIQUE(A2:A100)
Google Sheets
=UNIQUE(A2:A100)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2:A100 is the range.
  2. 2Duplicates are removed; each value appears once.

Need a version for your data?

Try: “List the unique values from column A”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: