=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