Mode function in Excel returns the most frequently occurring, or repetitive value, in an array or range of data. Syntax: mode(number1, number2,...). Number1, Number2, ...are 1 to 30 numbers, or arrays or names or references that contain numbers for which you want to find the mode value. For example, mode(1,2,3,2) returns the value 2 which is repetitive.