How to Count Unique Text Values (or Numbers) in Excel - Count Unique Values in a range

In this video, I'll show you how to get a count of unique text or numeric values in Excel. The tutorial includes two alternative ways to get the number of unique values. The first method will work in any version of Excel using the SUM and COUTIF Functions. The second method uses the powerful UTEXT function.

Tutorial:

Chapters:
00:00 Intro
00:08 How to count unique values in Excel

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

🎁 SHARE this video and spread the Excel love.

Or if you are in a hurry, please click the 👍

#exceltips #exceltutorial #excel #msexcel

[voltairefelgrand]

Function for counting unique values in a column. (B2:B23 is a filler range. Just replace with the range you want. Works in libre office. I have not tried excel)

For texts and numbers:
=SUM(IF(FREQUENCY(IF(LEN(B2:B23)>0, MATCH(B2:B23, B2:B23, 0), ""), IF(LEN(B2:B23)>0, MATCH(B2:B23, B2:B23, 0), ""))>0, 1))

For numbers:
=SUM(IF(FREQUENCY(B2:B23, B2:B23)>0, 1))