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.