Excel Array Formula Series #8: FREQUENCY function

Description

See how to use the Array FREQUNCY function correctly. See how to use the FREQUNCY function to counts occurrences in categories. Then use the frequencies to build Frequency Distributions and Histograms. In thisseries see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions....