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 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 a data where there is manager wise CP Code which is duplicate and there are many segments for many CP Code, 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 Handel Error 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...