excel count Duplicate values only once |how to count unique names in excel ||unique formula in excel

hi i am manoj kumar
in this video, we are going to learn about the how-to count the unique value in excel, with the help of sumproduct formula and count if,
excel count duplicate values only once
how to count unique names in excel
count duplicate values in excel
count unique values with multiple criteria
counta
unique formula in excel
countif
counta
sumproduct
count
excel,
by‪@manojkumarexcel‬ from bhorha simri bakhtiyarpur saharsa bihar

[@amrit894]

BIG like 7****nice presentation Dil Ko chhu lene wali video 🙏🕉️🇭🇺🌷💯

[@friendscollectionzariwork4660]

Great job very nice

[@AditiNath1234]

Great job very nice👍

[@rhfashionpoint7085]

Great sharing

[@RedhillsRecipes]

Good tutorial 👍

[@mamtaseth7780]

Good 👍 sharing dear ♥

[@PunjabiLifeunique]

7 like nice sharing

[@vocalistmukeshnath]

Gud Shearing

[@JoecelynMalhi]

This is so excellent👍👌

[@astroshivbhakti]

13
Another good one

[@vanitaskitchen950]

Doing a great work and very well explained, thanks for sharing, have a great day

[@lizpena1816]

Excelente tutorial amigo saludos

[@umeshofficial4967]

Nice sir 👌

[@onlywishes]

nice

[@shuklaedugalaxy]

Super super video Manoj ji aap bahut Sundar badi acchi jankari de rahe logon Ko is jankari ko lene ke liye logon ko paise dene padte Hain yahan to aap free mein badh rahe hain aap mahan hai 🙏

[@aaishaeducation]

Great sir 11 👍👍👍👍
Plzzz aap bhi aaye 🙏🙏🙏

[@koshishekasha103k]

Great day great sharing✅

[@sapnasehar7195]

Waoo great share Ik

[@pitbullloverhr6348]

Thanks a lot to you sir

[@easyrecipe5428]

Waoooo👍 very very great video sir You will definitely succeed one day, you work very hard Best of luck 👍👍👌🙋

[@TeamVikas]

Very Good Manoj sir..👌

[@NityaBhajanMala]

Nice

[@vinodraikwarmandiofficelal7893]

Jai shree radhe radhe ji

[@SARA-rb4qw]

1~♡ hi

[@sashibhusanmuduli6131]

Great sir thanks you so much ........

[@VijayKumar-cj5ig]

Thank you sir ji

[@VijayKumar-cj5ig]

Thank you sir

[@winnertech3240]

Make it work on filtered data. Suppose I filter the names in column A.

[@miqbal7032]

Count unique name with item name in table by excel

[@faraznaeem9013]

Great .. sir how to apply this formula with condition of minus unwanted cell in total count

[@winnertech3240]

How will it work on filtered data?

[@dominic2827]

Ty

[@manojkumarexcel]

thanks

[@mayanklaul-hn3gm]

SIR , IF we WANT TO FIND OUT HOW MNAY TIMES (each cell is occuring in entire sheet )
MANOJ KUMAR IS OCCURING , HARSH , ETC.......

[@Ravikumar-mw7xd]

Sir how to apply SORT and UNIQUE Function in Excel 2019

[@artfun7907]

i have two spared sheets one is called stock with price
and another is called calculator
in a stock sheet there is 3 columns category and sub category and price
that shows in calculator sheet in list form
i am not able to get a specific price of category and subcategory wise
ex fruit is category and apple is sub category and 100 is price
in calculator sheet fruit and apple are showing but how can i get the price of it
please help me............
looking to hear from you..

[@anjanikumar5121]

Manoj sir
Agar a column mein company name ho and B mein name, to a company mein kitne employee hai, kaise count karenge

[@manojkumarexcel]

ruclips.net/video/gq5X9TU0_Kk/видео.html

[@mr.bhatti9324]

Sir, How can we apply this formula with multiple filters in Excel's columns???

[@manojkumarexcel]

[e-mail]

[@Preventivehealthcarenavjot]

IT SPREADING VALUE DOWN

[@muhammadtouseefanjum1462]

what will be modifications in formula if we do not want to count a specific value.

[@manojkumarexcel]

You want to count full or unique value

[@muhammadtouseefanjum1462]

@@manojkumarexcel I have used this formula to count excluding duplicates =SUMPRODUCT(1/COUNTIF(B3:Y3,B3:Y3)) how this formula can be modified to not include to specific value.

[@manojkumarexcel]

Using countif formula cout the specific value and subtract from from total

[@muhammadtouseefanjum1462]

@@manojkumarexcel if we have a large dataset, it would be difficult to find.

[@this_is_me_now]

This is not English...

[@manojkumarexcel]

Contact
[e-mail]