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👇

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

Excel Dashboard Automation👇

How many Sundays between two dates?👇

Calculate the Age in Excel👇

How to Handel Error in Excel?👇

Extract Number From Text no VBA👇

Interesting things about HLOOKUP 👇

Filter Function 👇

Unique Function👇

Download the Practice File Here 👇

[parthomukherjee]

good explanation but please avoid adding music while explaining

[amanjjalal]

Dear Sir, How can I fix the data that is not in the table but writes 1 in the result

[sukkurimran]

Thanks, dear I searched for this solution for a long.

[Pro-Tips-Tricks]

Hey, Can you Input a coloumn with Product Amounts then make summary on sum of product amounts with unique segments and products, i m very thankful if you do this for me.

[RizwanAli-vidh]

Good explanation..
My problem solved.

[thestranger]

Very helpful. However, I'm stuck with a problem. Instead of managers, I've got dates and i want the same filter to work for future dates as well

[sakshamtiwari]

Old method sir, we have very advanced functions by their combination of use, it can be a lot easier.

[adarshag]

Good video, Kindly release English Version also, , ,

[foreverrahul]

Great solution. But if we have blank cell in our data then it give you one extra count. how to ignore it

[vinaymahabdi]

Dear Sir how to do sumproduct formula in extra range like blanck cell in multiple criteria, please advice ..Thank you in advance..

[Cool_Siddhesh]

Second formula using in office 365 not a perfect there is some issue. If there is a another item in segment just like a printer but if is not in your data the result for this segment its zero but using this formula it shows one value for this segment how is possible if this segment is not in data.

[storieswithtarasharma]

MS 365 wala formula chalega nahi agar condition aisi ho ki filter ki value 0 ho to unique count error hoga or counta use result 1 consider karega which is wrong

[prakashbhaisuthar]

Sir, what is formula for counting unique value of different cell? for example In A1 cell has the text 'teacher' C1 cell has the text 'teacher' E1 Cell has the text 'teacher but In B1, D1 has not the text 'teacher'. how can we use formula for counting A1+C1+E1

[marysy]

how about this formula counta(unique(filter and with specific range date. would be very glad if you could teach me how
thank you

[darinlinares]

Hi sir how to skip duplicate & count without delete any data? Is there any equation for this?

[himanshu]

how to absent employees name highlight according to date in attendance sheet

[mohammadaijaz]

Superb Sir, Meri bhi ek query hai.
Sir Meri Query ye hai Apple 1 bar aya to usko unique value ke saath count bhi kiya jaye jaise 1/1 or jab dobara aye to 1/2 or phir dobara aye to 1/3 resut mile isi tarah Laptop 2/1, 2/2, 2/3 or Tablet 3/1, 3/2 Samajh Orange 4/1 Samajh gaye na Sir please meri ye query aap solve karden plz...

[TheSoni]

Sir agar blank hi cp code to count Nhi kr rha unique me cp code pls suggest...

[bhukkadengineerr]

I have issue in one excel sheet kya aap help kr skte hain?

[suggestme]

Counta returns 1 when answer is zero ..
Cloud you please please me to fix this