Learn how to count unique values in Excel. We’ll be talking about two different senses of the word ‘unique’, hence two different ways to count unique values, both quick and easy. That way, you’ll be able to pick the right calculation depending on the situation. Let’s start!

Copy the formula below and paste it into the target cell

Unique Values (Among Duplicates)
=SUMPRODUCT(1/COUNTIF(***,***))

Unique Values (Without Any Duplications)
=SUM(IF(COUNTIF(***,***)=1,1,0))

Don’t miss out a great opportunity to learn:

How to Remove Blank Rows in Excel - BASIC
► https://youtu.be/Ik7LRq7-COU

How to Remove Blank Rows in Excel - ADVANCED
► https://youtu.be/0a4TgCVbX_k

How to Remove Duplicates in Excel
► https://youtu.be/g_NmTjzUHBA

How to Find Duplicates in Excel:
► https://www.youtube.com/watch?v=eAeFRAAwBe0

===============

️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
YouTube ► https://www.youtube.com/@ExcelTutorialsEasyClickAcademy/join

===============

⏱️Timestamps⏱️
0:00 Intro
1:46 How to Count Unique Values in Excel - First Instance
3:32 How to Count Unique Values in Excel - Single Occurrences
4:30 How to Count Unique Values in Excel with Empty Cells

================

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)
► https://www.youtube.com/c/ExcelTutorialsByEasyClickAcademy?sub_confirmation=1

How to Count Unique Values in Excel (Quick and Easy)
► https://www.easyclickacademy.com/how-to-count-unique-values-in-excel?utm_source=Popis&utm_medium=YouTube&utm_campaign=How%20to%20Count%20Unique%20Values%20in%20Excel%20(Quick%20and%20Easy)

Got Microsoft Office 365? Get it here
► https://www.easyclickacademy.com/buy-microsoft-office?utm_source=Popis&utm_medium=YouTube&utm_campaign=How%20to%20Count%20Unique%20Values%20in%20Excel%20(Quick%20and%20Easy)

Connect:
LinkedIn ► https://www.linkedin.com/company/easyclickacademy
Facebook ► https://www.facebook.com/EasyClickAcademy
Web ► https://www.easyclickacademy.com

Screen Recorder & Video Editor:
Camtasia ► https://techsmith.pxf.io/c/1266206/347799/5161?u=https%3A%2F%2Fwww.techsmith.com%2Fvideo-editor.html

#MicrosoftExcel #ExcelQuickAndEasy #EasyClickAcademy