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

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

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

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

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