FREQUENCY function


Get the frequency of values in a data set.



=FREQUENCY( data_arraybins_array )


required arguments:

data_array An array of values for which you want to get frequencies.
bins_array An array of intervals (“bins”) for grouping values.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.