Excel Forum
Similar Content
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Sum a Range with Errors in Excel
Tutorial: How to sum a range of cells that contains errors. This requires an array formula, so it w...
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....

Excel Array Formula Series #8: FREQUENCY function

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 this series 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.

Also see:

Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)

Got a Question? Ask it Here in the Forum.