Excel Count Unique Values

How to Count Unique Values in Excel with Multiple Criteria

This article will show you some methods to count unique values in an Excel worksheet based on different criteria. The Excel worksheet can count ...

Count Unique Values with Criteria using the COUNTIFS Function in EXCEL – 4 Examples

The COUNTIFS Function The COUNTIFS function counts the number of cells in a range that match one of the provided conditions. Syntax COUNTIFS ...

Excel VBA: Count Unique Values in a Column (3 Methods)

  Overview of the Code Sub Number_of_Values_that_Appear_Only_Once_1() Set Rng = Range("C4:C15") Count = 0 For i = 1 To ...

How to Count Unique Values in a Filtered Column in Excel (5 Methods)

Dataset Overview In our dataset, we have information on the Quantity and Sales of various Product Categories, along with Order Dates and ...

How to Count Unique Values Based on Criteria in Another Column in Excel (4 Methods)

Dataset Overview Imagine we have an Excel file containing data about various fruits exported by a businessman to different European countries. The ...

How to Use COUNTIF for Unique Text (8 Easiest Ways)

We'll use a sample dataset of sales information. The dataset contains two columns: Sales Person and Sales. Let's extract the unique values. ...

COUNTIFS Unique Values in Excel (4 Easy Ways)

We’re going to use a Customer Record of Mars Group. This sample dataset includes some Product Names and Contact Addresses of the Customers who bought ...

How to Count Unique Names in Excel (6 Simple Methods)

In this article, we will demonstrate some methods to count unique names in Excel. Excel doesn't have a built-in function to count unique values or ...

Excel SUMPRODUCT Function to Count Unique Values with Criteria

We have a dataset with Brand names, Device Categories, Model No, and Units Sold. We want to know how many brands (unique values) are selling ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo