How to compare data ranges with intervals in Excel ?

To compare data range with intervals in Excel, we can use the FREQUENCY Function

This function is used to compare data range with intervals. The output displayed is the number of items in the range of data that fall between the intervals. The function is enclosed in braces because it is entered  in the cells as array.

Syntax:

=FREQUENCY(RangeOfData,ListOfIntervals)

Formatting 

No significant formatting is required.

Example:

Excel is fun.... :)