Mode.mult array function not displaying formulas

[DrBacon]

Hello all,

I have the several values, and just by looking at it, there are 3 values that repeat the most, 24, 47 and 30. But when I use the mode.mult in an array formula, it only displays 25. Even if I select 3 cells to use the array formula, all 3 cells show 25. How can I correct this?

Amount USD
5
5
5
25
25
25
25
25
25
25
25
25
25
25
25
25
25
25
28
30
30
30
35
40
47.28
47.28
47.28
47.28
47.28 ​

<colgroup><col></colgroup><tbody>
</tbody>

 

[Marcelo Branco]

MODE.MULT shows multiple results only when there are multiple values with the highest frequency. It is not your case because only 25 has 15 occurrences (highest frequency), while 47.28 occurs 5 times, and 5 occurs 3 times.

To get the number with the highest frequency , the second and the third, try something like...

	A​	B​	C​
1​	Amount USD​		Result​
2​	5​		25​
3​	5​		47,28​
4​	5​		5​
5​	25​
6​	25​
7​	25​
8​	25​
9​	25​
10​	25​
11​	25​
12​	25​
13​	25​
14​	25​
15​	25​
16​	25​
17​	25​
18​	25​
19​	25​
20​	28​
21​	30​
22​	30​
23​	30​
24​	35​
25​	40​
26​	47,28​
27​	47,28​
28​	47,28​
29​	47,28​
30​	47,28​

Array formula in C2 copied down
=MODE(IF(ISNA(MATCH(A$2:A$30,C$1:C1,0)),A$2:A$30))
Ctrl+Shift+Enter

M.

 

[DrBacon]

I did exactly this, but this only returned 25 3 times. Not sure what I might be doing wrong.

 

[Marcelo Branco]

What formula did you use?

M.