Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > MODE
 

MODE(number1 [,number2] [, …])

 
 Returns the number that occurs most frequently in a range.

 number1The first number.
 number2The second number.

 REMARKS
 
  		• The arguments have to be numbers.
     
  		• The arguments can be range names, arrays, or references but they must 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.
     
  		• If the data set contains no duplicate data points, then #N/A is returned.
     
  		• You can have a maximum of 30 arguments.

     EXAMPLES
     
     A
    1=MODE({5.6,4,4,3,2,4}) = 4
    2=MODE({1,1,1,1,3,3,3,3,4,4,4,4}) = 1
    3=MODE(2,4,6,8) = #N/A
    		 
     Functions - M | Index - M | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top