MODE Function

The MODE function is used to find the number/entry which has appeared frequently in a group. It returns #N/A if all the entry is unique.
Note: If there are more than one set of duplicates, it returns the one which is close to the beginning of the group.

Formula:


=MODE(Range 1,Range 2,Range 3...up to Range 255)

Video Tutorial:


Let us find the mode of the given set of numbers, using the MODE function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question