Returns the most frequently occurring, or repetitive, value in an array or range of data. Like MEDIAN, MODE is a location measure.

Parameters :

range

is an array or a reference to cells that contain numbers for which you want to calculate the mode.