Excel Trick - How To Count Unique Values In A Range With COUNTIF In Excel || dptutorials

Excel Trick - How To Count Unique Values In A Range With COUNTIF In Excel || dptutorials

If you need to count the number of unique values in a range of cells, you can do by using the countif and sumproduct functions

Best Laptops to use for better speed:

Our Recommendations
***************************************************************

If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.

***********************************************

⚡️Tools for YouTube vlogging:
***********************************************
***********************************************

⚡️You Can Connect with Me at:
***********************************************

#dptutorials #Exceltraining #uniquevaluesinexcel #ExcelTips #ExcelFreeTraining #ExcelFreeLearning

⚡️Tags: -
excel formulas in English, excel in English, excel tutorial in English,ms excel in english,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in Hindi, excel formulas and functions in Hindi, excel tricks, excel in Hindi, excel shortcut keys, excel vlookup, excel formulas in Hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, Excel Sum Formula, Sum Formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft excel training, dptutorials,excel formulas,Excel tricks,Excel help,Excel tips,Microsoft Excel,count,unique,entries,calculate,data,count unique entries,unique entries excel,count unique entries excel,count unique values excel,count excel unique values,count excel unique text,unique values,unique values in excel,unique values from two columns in excel,unique values in drop down in excel,countifs unique values,countifs unique values multiple criteria,countifs unique,countifs

⚡️Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

[annzalucki]

Finally, an excel video that clearly showed me how to do this! Excellent! Thank you!

[vaseembaig]

you are amazing! What a handy technique! Thank you so so much!

[jlombardo]

Excellent, Thank you. Excellent to count data in columns with blank spaces!!! Great

[BobBevill]

Fantastic!!! Other methods would result in a DIV/0. This works perfectly!!! Thank you.

[mowgli]

Hello - Can I still count unique values if they are pulled through via a vlookup and or filtered?
I've looked up values to tell me whether certain employees are within a spreadsheet. and now I need to count to see just how many of those employees returned. there are duplicates; so I need to count the unique values only and disregard any #N/A's. I also need the number to adjust if filtered

[simpledudz]

Thank you, ,, how about furmula to count unique value in defferent cell/ not in a range of cell, , exclude zero and blank?

[simpledudz]

Hi can you make another video how count unique values exclude 0, blank, in deferent cell/separeted column??

[Rupesh]

Thank you....Can u please provide me the formula for "Count Unique Values in a Column A if Column B is "AAA" ad Column C is "BBB"

[tonywakim]

=counta(unique(range)) <--- i find that to be easier

[md.jinnah]

How find out division wise unique number count.

[Patric]

Try ; in case the formular doesnt work with,