Excel Frequency - Free Excel Tutorial

How to Count Unique Numeric Values in a Range in Excel

This post will guide you how to count unique numeric values in the given range in Excel 2013/2016 or Excel office 365. How do I count the unique numeric values in a list of data with some duplicate values using a formula in Excel. And you can use a formula that uses the SUM function… read more »

How to Count Unique Dates in Excel

This post will guide you how to count unique dates in a given range in Excel 2013/2016 or Excel office 365. How do I count the unique dates in a list of dates with some duplicate dates using a formula in Excel. And you can do this by a formula based on the SUMPRODUCT function… read more »

Excel FREQUENCY Function

This post will guide you how to use the FREQUENCY function with syntax and examples in Microsoft excel. Description The Excel FREQUENCY function calculates how often values occur within a range of values. And it will return a vertical array of numbers. For example, you can use the FREQUENCY function to get the number of scores… read more »

Sidebar