How to Count Unique Values with Multiple Condition in Excel

Sometimes we are working in Excel, and suddenly there are some difficulties. After a lot of trouble, if the solution is not found, then we try to do it manually. Something similar happened with me, and I too was stuck right there, but after many ideas and research, I have finally solved this problem, which is described in detail in this video.

Let us first understand the questions -

Q1. - I have data where there is manager wise CP Code that is a duplicate, and there are many segments for many CP Codes, so first we have to know the count of unique CP Code manager-wise.

Q2. - From the same data, we have required the segment-wise unique CP code for each manager.

I have solved this problem with two different examples.

Formulas Used to solve the query
#COUNTIFS
#SUMPRODUCT
#FILTER
#UNIQUE
#COUNTA

Subscribe to YouTube & Follow on Dailymotion and Like Facebook Page👇
   / exceluniverse  
https://www.dailymotion.com/exceluniv...
www.facebook.com/exceluniverse.pkp

**********************************************
Checkout Some Other Excel Tutorials Videos:

Excel Dashboard Automation👇
   • Excel Dashboard Automation || Dynamic Rang...  

How many Sundays between two dates?👇
   • Count Day of Week Between Dates in Excel  

Calculate the Age in Excel👇
   • DATEDIF Function in Excel  

How to Handle Errors in Excel?👇
   • Excel Error Handler Functions-IFERROR || IFNA  

Extract Number From Text no VBA👇
   • Extract Numbers From Text in Excel  

Interesting things about HLOOKUP 👇
   • Reverse lookup in excel with HLOOKUP  

Filter Function 👇
   • Filter Function in Excel - Best Way of Lookup  

Unique Function👇
   • Ms Excel UNIQUE Function | How to use Uniq...  

Download the Practice File Here 👇
https://mega.nz/file/pqp0TBpQ#zSOlsBq...