Excel Forum
Similar Content
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Average Non-Contiguous Cells in Excel
Tutorial: How to average non-contiguous cells (cells that aren't next to each other) if those cells...
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...

Mr Excel & excelisfun Trick 15: Frequency Distribution

See Mr Excel use a Pivot Table with Grouping and a Count function to create a Frequency Distribution. See excel is fun use the FREQUENCY function (upper limit is included in count) to create a Frequency Distribution and use the SUMPRODUCT, COUNTIFS, and COUNTIF functions (upper limit is not included in count) to create a Frequency Distribution.

Got a Question? Ask it Here in the Forum.