mode
Syntax:
Value
Number
mode
(
Range
source)
Description:
Computes the mode of
source
(most common element).
Examples:
($d4) = mode($a1:$c3)
Before:
A
B
C
D
1
1
6
7
2
12
4
6
3
6
-5
12
4
5
6
After:
A
B
C
D
1
1
6
7
2
12
4
6
3
6
-5
12
4
6
5
6
($a1) = mode($b1:$f20)