Excel 365 + Google Sheets · COUNTA + UNIQUE

Count unique values

UNIQUE removes repeats and COUNTA counts what's left.

The formula

=COUNTA(UNIQUE(A2:A7))

What each part means

UNIQUE(A2:A7)Each client once
COUNTA(...)How many

Example

Before

	A	B
1	Client	Unique clients
2	Acme
3	Bolt
4	Acme
5	Cora
6	Bolt
7	Dyno

After

	A	B
1	Client	Unique clients
2	Acme	4
3	Bolt
4	Acme
5	Cora
6	Bolt
7	Dyno

Step by step

Click cell B2.
Type the formula: =COUNTA(UNIQUE(A2:A7))
Press Enter.

Where it works

Excel 365 and Excel 2021 or newer
Google Sheets
Excel for the web (free)

The same formula in other languages

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

TEXTAFTERCut any text after a character AI promptInitials from any name, written by AI LARGEYour top 3 in one formula ROUNDRound any number the right way Below targetSpot who's below target SUBSTITUTEReplace any character everywhere