In this tutorial, let us learn how to Count unique numeric values in a range using the combination of Frequency and Sum functions
Let us consider this example of data table and get the count of unique numbers in cell F4.
Type the formula in cell F4 as = Sum(--(Frequency(B5:C12,B5:C12)>0)) and press enter to see the result as "8".
So, here what we have done is. We have calculated the frequency of the repeated numbers.
You can use other functions like for example =Sumproduct(1/Countif(B5:C12,B5:C12)) which gives the same result.
There are more functions as well to do the same calculation. But, I feel this as the simplest way to calculate.
I hope you have enjoyed this tutorial, you can support me by: buymeacoffee
Watch this video tutorial for better understanding:
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you. You can write us at info@dptutorials.com Best Laptops to use for better speed: 1️⃣ https://amzn.to/3lf8zYU 2️⃣ https://amzn.to/3xejpAW 3️⃣ https://amzn.to/379OqeL Best Equipment & Tools for YouTube Channel : ➡️ https://bit.ly/3inKa1P
Our Recommendations *************************************************************** Oracle Primavera Tutorials : https://bit.ly/3fn9PFH Microsoft Excel Tutorials : https://bit.ly/2V5de5l Microsoft Project Tutorials : https://bit.ly/37guNl7 *********************************************** ★ My Online Tutorials ► https://www.dptutorials.com ⚡️LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources ⚡️Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2 ⚡️Support the Channel via shopping: https://amzn.to/2ZRfTOZ http://ift.tt/2jH38PR ⚡️Tools for YouTube vlogging: *********************************************** ⚡️You Can Connect with Me at: *********************************************** YouTube: http://www.youtube.com/c/dptutorials Instagram: https://www.instagram.com/dptutorials/ G+: http://ift.tt/2kAOpa6 Twitter: https://twitter.com/dptutorials15 Facebook: http://ift.tt/2kfRnDi BlogSpot: http://ift.tt/2kB14dh Websites: http://www.dptutorials.com & http://www.askplanner.blogspot.com #dptutorials #Exceltraining #uniquevaluesinexcel #ExcelTips #ExcelFreeTraining #ExcelFreeLearning
Comments