As an example, you might have a list of employee scores and want to display the frequency of scores within certain ranges. Using Excel 2013's Frequency function as an array quickly compiles the ...

For example, if you want to show a frequency distribution for every 10 units you would need to define that for Excel. The Frequency function refers to this limit as the "Bin Array." ...

However, the Filter function can be placed anywhere in the workbook. The function also can be used along with other functions and formulas, which makes it capable of performing some amazing feats. So ...