Enter the formula. The formula instructs Excel to do the following. Because FREQUENCY returns an array it must be entered as an array formula.
Data_arrays It is a required argument This is an array or reference.
Fill the A1 and B1 cells with the data titles. The Excel FREQUENCY function returns a frequency distribution which is a summary table that shows the frequency of each value in a range. Because FREQUENCY returns an array it must be entered as an array formula. Open your project in Excel.