Home : MODE
Q11562 - INFO: MODE

MODE (Primitive Spread Function) returns the most frequently occurring value in a set of data.

SYNTAX:

MODE(value1,value2,...)

REMARKS:

Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.

If no value occurs more than once, the function does not return a value. If more than one value occurs the same number of times, the function returns the first value that repeats that same number of times. 

EXAMPLES:

MODE(A3,B3,C3,D3)
MODE(A1:A9)
MODE(89,95,88,97,88,74)=88
MODE(1,2,2,3,4,5,5)=2

Related Articles
Q11514 - INFO: AVERAGE
Q11555 - INFO: MEDIAN
Q11581 - INFO: RANK

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 8/27/2008 10:27 AM.
Last Modified on 8/27/2008 10:27 AM.
Last Modified by No Author Name Available!.
Article has been viewed 2832 times.
Rated 7 out of 10 based on 2 votes.
Print Article
Email Article