Frequency Function in Excel | Advance Excel Course

The FREQUENCY function in Excel help you to calculating the frequency (no of repeated value) of a data set within a given range of values. It means how many times a data value has occurred amongst a given set of values.


=FREQUENCY(data_array, bins_array)

Data_array – It is an array or reference to a set of certain values whose frequencies we need to count.

Bins_array– It is an array or reference of unique data into which you want to group the values in “data array.”

How to apply FREQUENCY function in MS excel ? 

Step 1 Apply Formula

Step 2 Drag All and select cells where formula applied

Step 3 Press F2 Key from keyboard

Step 4 Press CTRL + SHIFT + ENTER key from keyboard at a time