by 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.
Syntax
=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
