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...