WorksheetFunction.Mode_Mult method (Excel)

Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of data.


expression. Mode_Mult( _Arg1_ , _Arg2_ , _Arg3_ , _Arg4_ , _Arg5_ , _Arg6_ , _Arg7_ , _Arg8_ , _Arg9_ , _Arg10_ , _Arg11_ , _Arg12_ , _Arg13_ , _Arg14_ , _Arg15_ , _Arg16_ , _Arg17_ , _Arg18_ , _Arg19_ , _Arg20_ , _Arg21_ , _Arg22_ , _Arg23_ , _Arg24_ , _Arg25_ , _Arg26_ , _Arg27_ , _Arg28_ , _Arg29_ , _Arg30_ )

expression A variable that represents a 'WorksheetFunction' object.


Name Required/Optional Data type Description
Arg1 Required Variant Number1 - The first number argument for which you want to calculate the mode.
Arg2 - Arg30 Optional Variant Number2 - Number30 - Number arguments from 2 to 30 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.

Return value



  • Arguments can either be numbers or names, arrays, or references that contain numbers.

  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

  • Arguments that are error values or text that cannot be translated into numbers cause errors.

  • If the data set contains no duplicate data points, MODE_MULT returns the #N/A error value.

See also

WorksheetFunction Object