# Mode.Mult giving me problem

##### Well-known Member
Hello Guys,

I have used the function Mode.Mult with success in the past, but for some reason it is not working for me now. I have the following range
 9 55 92 -32 -51 14 48 37 14 -29 2 -8 55 -59 133

<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>
When I use mode.mult and enter as an array, it gives me only 55 as the answer. It is same when I use mode, or muode.mult without array. The answer I want is 14, 55.

Thanks for all the help.

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Try this -
In the example below I selected cells C2 & C3 (you need to select enough rows to cover the modes) then put in the formula and confirmed with
Excel Workbook
ABC
19Modes
25555
39214
4-32
5-51
614
748
837
914
10-29
112
12-8
1355
14-59
15133
CTRL-SHIFT-ENTER.

Thanks for that. But, I thought that the answers will be in one cell and shown as 14,55.

Is there another way for achieving that sort of result (14,55) in same cell?

Only by joining them in another cell I believe

Excel 2010
ABC
19Modes
25555
39214
4-3255,14
5-51
614
748
837
914
10-29
112
12-8
1355
14-59
15133
Charlie
Cell Formulas
RangeFormula
C4=C2&","&C3
C2:C3{=MODE.MULT(A1:A15)}
Press CTRL+SHIFT+ENTER to enter array formulas.

Thanks Michael.

But the real issue is that the data is huge and the number of answers will be different in each instance (1000s of them). So I cannot have a general formula for set number of cells to be included in mode.mult function.

Anyway, if there is no work around to my problem, I guess I will have to live with it.

Thanks a lot.

Replies
4
Views
254
Replies
7
Views
157
Replies
3
Views
119
Replies
1
Views
57
Replies
1
Views
245

1,203,673
Messages
6,056,677
Members
444,881
Latest member
Stu2407

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back