Unique Count in Excel | How to count Unique Values in a list using Sumproduct and CountIF Formula

[@rajankumarmishra4057]

Hi Dilip Sir, I am glad to inform you that your video is too effective and simple to understand its logic of functions and formulas. I don't have word to express myself about your youtube tutorials. i have learnt a lot in excel and on daily basis, i try to learn and practice more. Thank you so much to prepare such kind of important and useful videos who wants to learn through youtube channel. I also inform you that in my initial time, i had subscribed your channel.

[@Innozant]

Thanks Rajan for your valuable appreciation.Really means a lof to me.Keep Learning & Keep Exploring👍

[@Herukamahesh]

...aapka dil bohot bada hai bhai....free main itne knowledge sab ko dete ho....🙏...God bless....!!! You are man of integrity...!!!

[@Innozant]

Thanks dear...Keep Learning ❤️

[@ranvir0392]

Best method to find count unique values.......best teacher ever.....

[@Innozant]

Thanks Ranvir for yout valuable appreciation ❤️❤️🙏🙏

[@iamsainipawan]

Sir I have. I word to describe your teaching methods but I'm happy to have you my excel teacher who teach me excel very easy and deeply way which no one can do ❤️🙏sir god bless you 👍

[@Innozant]

Thanks Pawan for your valuable appreciation dear.Really means a lot to me

[@thetourminator]

Holy krap ! Just got done watching 3 other videos on this topic trying to do what you say at 3:30, but watching those videos (English speakers, and I only understand English) well none of those videos explained how to do what I needed. Just watched this video and despite him speaking a language I can't decipher, I was able to understand how to do what I needed to do in EXCEL (again, 3:30 of video). This dude is awesome....excellent visuals.

[@sandeepaswal8944]

नमस्ते सर जी, सर आपने Sumproduct and CountIF with Unique Values बहुत ही डिटेल मैं और अच्छे से समझाया | मुझे आज नई चीज़ सीखने को मिली | आपका बहुत बहुत धन्यवाद सर जी |

[@Innozant]

Thanks Sandeep Ji..Aaj Live Interview of MIS EXECUTIVE video aane wala hai..must watch

[@suvadipnarayanchowdhury4614]

I have seen so many tutorials in KZbin, but your way of explaining the logic and why it is happening is just WOW...Lots and lots of applause to you for making such great and true learning videos. You are truly doing good to the overall IT Industry and social well being. Social well being because, positivity comes from knowledge and you are sharing your knowledge which is being converted into positivity. Thanks a lot...Please continue this good work...

[@Innozant]

M speechless..Thanks Chowdhury sahab..Hope these video tutorials will adds some values in your life..Thanks for being part of Innozant family .

[@hamzazayd3463]

Way of explanation is excellent, thanks for sharing your vedios.

[@iamsainipawan]

Before subscribed your channel sir I saw many of you tube channel but didn't get kind of content what you deliver for your learner how easily and deeply you described concept is fantastic sir 🙏I learnt lot of tricks and basic of excel for last one month which is unbelievable for me as bigners 🙏 sir

[@Innozant]

Thanks Pawana ji.Learn ..enhance your skills on regular basis..❤️

[@vikramgupta3827]

Sir, excellent video, aapne bahut easy kar diya

[@Innozant]

Thanks Vikram Ji

[@alpeshpanchal7994]

Nice video.. i am looking this formula from last 1 week.... Thanks.

[@yogeshrao5924]

Thank you Dilip sir Maa kali or apke sahyog se mujhe kaafi Kuch shikhne ko mila apne mujhe creative bna diya dhanyavaad gurujii jai maa kali ❤

[@SLOANchetan]

Best indian excel guide!!🔥🔥

[@Innozant]

Thanks dear

[@jk-iz7ow]

Sir ji apka vedio or smjane ka trika bhut acha h ase hi vedio bnate rhna

[@Innozant]

Thanks dear..Humesha milta rahega videos seekhne ko..

[@RMKserve]

My thirst for learning going to be increased day by day as I continue to watch your videos. This is quality of really guru🇵🇰🇵🇰❤️♥️

[@Innozant]

Thanks Raja Rizwan..Really means a lot to me dear..Happy learning

[@ankitasahu9645]

You are genius sir ,Thank you for this video😊😊

[@Innozant]

Thanks Ankita.. Really means a lot to me dear ❤️👍

[@ankitmehra3074]

sir app gyan ka sagar ho 🥰👌👌👌👌

[@Innozant]

Thanks Ankit❤️😊

[@mdbelayet7178]

Hi Dilip Sir, Will you please tell me the process to extract uncommon record set from different sheet or different workbook?

[@ArmanKhan-iq3ji]

Omg thank you for sharing this wonderful video I'm searching this method from past 2 weeks

[@Innozant]

Thanks Arman...Happy learning dear..God bless you..Happy learning

[@Aggrey_Nkololo]

YOU ARE BRILLIANT!

[@satishojha6240]

Sir your excel video mindblowing and encouraged to all excel learners.Good night

[@Innozant]

Thanks Satish ,Apke aise comments really mujhe motivate karta hai..acha. Sikhaun aplogon ko..aur aap life me aage badhen

[@AnandaKishoreBanerjee]

Respected Dilip Sir, Your video is too good to learn Excel. Sir I have a problem, how can I get unique man power in sum count between time.

[@shrikantbadge3978]

I am moving out of my comfort zone. There is still a lot to learn. Thanks Sir.

[@Innozant]

Best of luck my dear friend..Go ahead,Have a wonderful career.

[@shrikantbadge3978]

Ye series sabse alag hai sir. Baar bar dekhta hu mai

[@Innozant]

Good Shrikant..Aap revision mode on kar rakhe hain aapna..Keep growing

[@nitishjaiswal6216]

Amazing, I tried so many things but failed. This formula worked for me and I got the Solution. Thank You so Much Sir 🙏

[@Innozant]

Thanks dear ❤ Nitish for this valuable comment ..God bless you ..Happy learning

[@vikranthpatro1872]

Great way of explaining the things. Really nice 👌👌👌👌👌

[@Innozant]

Thanks Vikrant Ji.Happy learning

[@AhsanUllah-kt1sb]

Brother thanks for details explanation video, really it's awesome video. I have a request and for the solution. Same I need unique count with multiple criteria and one criteria from different columns

[@ShivamKatheriya-yz6wf]

Mind-blowing sir I have a question how to count of only capital letter Text in column

[@DeepakVerma-vb3uu]

your way of explanation if just amazing sir. if you have any video about extracting unique list from duplicate items with using formula, please share that video with me. i will.be very thankful to you for this ❤️

[@sarcar2370]

Can this be done with countifs

[@vishwadeeptayde5179]

Your way of teaching is quite good... Keep doing good work for learners...🙏

[@Innozant]

Thanks Vishwadeep ji..Happy learning

[@shreyabora4144]

Very well explained...

[@Innozant]

Thanks Shreya..Keep Learning ..Keep exploring

[@knowledgeseekersanju]

ek query hai sir, two column hai ek work ka, jisme ek date hai aur ek name, main chahata hu ki kisi ek ke naam se count karu woh kitne din woh kaam kiya (without pivot table). please help on this.

[@srikantamandal4858]

excel banane walo ko vi itna pata nehi hoga ki excel formula ko itna alag tarikha se cherkhani ki ja sakti hey. sir app jab formula likhte ho mere kheyal formula vi confused ho jati hongi ki karna keya tha or wo kar keya raha hey. hahhahahahhahahah. nice sir . very nice vdo.

[@Innozant]

Hahaha..Really means a lot to me..Aapke ye word mere liye kiss gift se kam nhi hai Srikanta.Aaapko humesha kuch better aur alaga seekhane ki koshish hogi meri

[@munishwarhajare643]

THANKS SIR!!!!!!

[@mahendrapratapsingh9890]

Great concept sir, Thanks, Kindly advice If I want to sum of "Salary" column for only unique occurrence. as this case, 4 kind of different unique occurrence then How to sum of salary column only for this occurrence

[@anilgami5257]

In same case if one more value like permanent employee or contract employee are use so how can count only contract employee or permanent employee

[@brijeshshah574]

So much respect for you Sir. The way you explained is too good.🙏 Sir how can I count unique value based on condition?

[@Innozant]

Thanks Brijesh ji...Aap series dekhte rhiye bht saare sawal ke jawan apko khud ba khud mil rahe honge

[@staterolife1651]

Excellent 👌 sir.. thanks for video.

[@Innozant]

Thanks Sandeep,Have a wonderful day. Happy Learning

[@vivekmusafir4492]

Thank you for your lessons...I have been using subtotal very often... mostly on top of headers...so whenever any particular name of company/person is selected using simple filter..subtotal automatically updates figures right on top...but that doesn't work when I want to see unique count of any particular field associated to that company or person selected through filter....I have applied combination of sumproduct and cuntif when filter isn't applied it gives me correct unique count...but when any particular company etc. Is selected..unique count remains same...because may be the range given in formula is static and not dynamic.. basically I want to see unique count being updated the way total is updated using subtotal... whenever filter is applied.....hope I was able to convey my query..

[@SarojKumar-dg1su]

Searching for this type of formula.. Thanks

[@Innozant]

❤️👍

[@hemantgusain1260]

Thanks you sir for explain such important topics.

[@Innozant]

Thanks Hemant,Happy Learning

[@BankerWriterMosharaf]

Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence

[@charviethakore651]

really good explanation

[@Innozant]

Thanks Charvie.We welcome you to experience the taste of success with Innozant -Seed of success. ❤️❤️❤️

[@knowledgeseekersanju]

bahut help hua sir

[@jindagijhand8391]

Sir can we find the last nth match value?

[@akak3585]

Thanks for videos sirG

[@Innozant]

Thanks dear ❤️

[@nishachauhan9103]

Sir 10:05 me aakhir me range ke sath ampersand kyu lagaya

[@rajnish94]

Sir, How to count Unique with multiple criteria like employee id wise channel partners...

[@vyankteshmozare8623]

Thankyou very much!

[@survesatishs]

Excellent!!!!

[@sujitkolhe1298]

insted of blank if few cells contain "-", then how to delete count of "-"

[@ayuvikarocks9136]

Sir unique count ka multiple sheet main bhi batao ek saath without unique and vstack ke

[@subramanyaba9297]

Good teaching

[@mukeshdak]

Amazing Thanks for this

[@gurunadhnaladi5722]

First of all thank you so much for making myself confident on excel day by day. Total credit goes to you only my dear brother... Pls suggest that how we can use this formula along with V-lookup

[@Innozant]

Thanks 🙏❤️

[@nancikalidin8629]

If the formula need to be done on a new worksheet..will that work? Am looking for formula to count unique values by country level means a lot of data

[@nancikalidin8629]

Want to know the count with duplicate and without duplicate values by country level (do we need a specific criteria from each sheet of country?)

[@moviesplit]

Sir agar hmaari range pure column ki hai A:A h tab kya karrnge.

[@devokedevtech2750]

Excellent sir

[@Innozant]

Thanks dear

[@pravinkharat5088]

Which formula for perticular item or party in different date comes and we have to count how many times that item/party in less than 7 Days and more than 7 Days in Big data.

[@abhijitdey1819]

Sir agar dono coloum me se ya 3 coloum me se unique count nikalna hai to kya formula hoga. Please suggest me

[@Innozant]

Distinct count bataya hua hai detail me maine ..pls check Excel maharaj playlist

[@fachryramdhani471]

Hallo Sir, how if I wanna use multiple criteria for instance "=Sumproduct(1/countifs(...))"?

[@Innozant]

You may check Playlist Interview crack recent episode crack jobs #24 q4 ,you may get the answer for the same.🙏❤️

[@fachryramdhani471]

@@Innozant Okay. I will check it. Thank you.

[@Papanmyprince]

Sir, Mere pas aysa hi ekta data he lekin sir usme employee visit many customer in a day some Times employee visit same customer two time in a day, mujhe duplicket valu nikal he using same employee visit same customer using function. Please help

[@sridhardubasi5088]

excellent sir..

[@Innozant]

Thanks Sridhar❤🙏

[@ABHISHEKSHARMA-vk9yd]

Wow. Me bhi excel me job karta hu but esa logic me kabhi nahi soch skta

[@Innozant]

👍

[@hiteshchourey9730]

Macro with pivot table ke saath kese banayege. Video banaye.

[@AjayKumar-ju4mf]

Sir how to get distinct count by formula ??

[@Noumanjavedshamsi]

Intelligent Sir

[@Innozant]

Thanks dear❤️

[@hirendrashriwas8021]

Sir दो batch example (batch 1 and batch 2 ) ki same date na ho vertical me ye kese kare...I am facing big problem pls help me sir, how can I show data to you sir.

[@dileepsant1606]

Sir yadi hame date wise unique value nakalana ho to kaise mikale agar hamare pass ek sal ka Data ho

[@PintuKumar-dt9bt]

can you tell me how to list unique name from 2 name list. in this video you have shown how to find unique name count .

[@primeknowledge99]

Thanks 👍

[@bhoopendraraghav9781]

Very nice sir.

[@Innozant]

Thanks Bhoopi

[@vdeva2766]

Sir. Ek video esi bnau jisme pivot k through unique value count sum kr ske plz..

[@jaybharat2374]

How count days between two dates of list of items pls

[@gear02]

Please help me unique count but only visible cell

[@abdulajij7569]

Mene kal ek mis ka interview join Kiya or mere se technical Excel ka question pucha gaya ki jisme customar name or customer ID di huyi thi or customar I'd common thi i reviewed ne bola ki unique I'd k aadhar par customer ki margin pickup karni h wo bhi without pivot table k please reply

[@sumitbhadrecha8211]

Sir How we count unique in filtered column having with mixed data #N/A

[@sumitbhadrecha8211]

Like column values 101, 103, #N/A, 101, 105. If we want to get unique value in filtered how we can get it.

[@kaaminikannoujia5730]

Agar ek data dusri sheet pr same chahiye pr unique sirf headers hai or koi id ya aisa kuchh unique nhi hai to kaise lekr ayenge..

[@vijaysahal4556]

you are really great sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻

[@Innozant]

thanks dear❤❤

[@ramzein776]

very useful video sir, for exa- column A has invoice no , column B has customer ID now I want to count the invoices of each customer ? it can be done using countifs range is customer id as it counts in that column how many Cus id are there as same invoice no, but if in column A some rows remains no invoice no column B row has Cus id the result will b wrong as it counts Cus id but in that specific row has no invoice no (for some reason say payment given for previous invoice) Pls advise how to find it

[@Innozant]

Rqmzein Sahab it's better you may share your query excel sheet on @innozantofficial telegram.will See your query and try this make time for the same

[@zameeruddin6381]

sir jee, i m from Pakistan, this sumproduct formula not working when we apply filters, please resolve ?

[@Harishckt1]

HiI have more than 50 Lakhs Products IDs and i need to findout duplicates out of this huge data. Pls assist with formula.

[@imranather74]

This use with filter kindly help

[@uniquemobiletipstricks7714]

Dive Deep Thats Innozant

[@Innozant]

Thanks

[@vishalbhati912]

Bahot bahatreen. Sabhi formulas ka aapne postmortem kar rakha he

[@Innozant]

😊👍

[@RudraStarP]

Jahan pr error a raha h bahan par if error ka bhi use ya fir if blank ka bhi use kar sakte h sir

[@Innozant]

Bikul iferror use kar lijiye ya..if aur uske inside iserror bhi kar sakte hain..better rhega koi bhi formula lagayen to uske bahar iferror jarur lagayen.

[@Innozant]

But is Question ke case me iferror se solution nhi ho payega jo hum chahte hain..hope aapko aajke video pasand aaye honge aur apne seekha hoga .

[@paribaghel1758]

Thnx u sir 🤗

[@Innozant]

Thanks Pari, Recommend you to start your learning journey from playlist Basic excel step by step in sequence followed with MIS interview cracker.Have a wonderful career ahead❤️❤️❤️👍

[@hamzazayd3463]

But this is not working in pivot for unique count with total

[@bishtlokesh1297]

Good sir ji

[@samadhan251]

Sir can you please make a video on Creating a unique List. (without using unique formula)?

[@Innozant]

Unique list question is already there in interview Cracker series.Ok will make seprate video for the same.❤️🙏

[@pushp38]

That was a great Tip. What if there lots of conditions. "Count Uniques with CountIfs"

[@Innozant]

❤️🙏

[@shantisawaroopsharma877]

Sir if I want to count Mondays or any other day present/absent only in an attendance sheet. How can I do it in excel. Kindly consider this urgent. Make a video on this topic

[@Innozant]

Kindly watch excel maharaj series..Your related solutions are there

[@sunnybest3412]

Good morning Sir Thank u sabhi videos k liye Main chahta hu apke is data me se dusri sheet me main employee I'd ek bar dalu to uske samne uski teeno salary aa jaye with formulas

[@Arunkumar-tt5gb]

Large data me duplicate hai osme se unique kaise nikale formule se sir...

[@Innozant]

Large data ho usse kya fark prega.Method unique value nikalne Ka ya to formula ya tool Kuch bhi use krke extract kr Skte h🙂

[@Arunkumar-tt5gb]

@@Innozant formula kya hoga iska nikalne agar koi number 5 br duplicate hai or osme se hume 1 chahiye kya formula lgayege

[@vikassinghjayara510]

Hello Sir, Thanks for making the videos and motivate us to learn always new things. As you explained the unique count without helping column, could you please help me to calculate the total count of duplicate value without helping column.

[@Innozant]

Ok..in upcoming videos will try to add this question.

[@vikassinghjayara510]

@@Innozant Thanks Sir. I will wait for that video.

[@vikranthpatro1872]

How to extract unique text data from a column ignoring blank in the next column ??? Any formula or solution???

[@Innozant]

Video are already there in tips and tricks playlist

[@dibyohere]

how use this function for filtered data in a table ?

[@Innozant]

There is no issue either we are applying on filtered or non filtered data

[@dibyohere]

@@Innozant nooo the result do not changes accordingly when the data is filtered.

[@mahfuzrahman5128]

how to findout unique count & Details Different cell, Please reply me 🙏🙏🙏

[@pksrichandan226]

How to count unique value in a column active cells like subtotal formula?

[@Innozant]

May be video is already there in tips and tricks playlist

[@pksrichandan226]

@@Innozant Sir, would you please write the formula please. Regards