Highest most occurring number in range.

Occasional Contributor

Hello :) 
(Sorry for my grammar mistakes.)

So from beginning I'll put picture of my table :)


We'll be talking about two things, "Enter N here" (A) and "M OCC Number" (B).
So as You can see in "A" i enter some numbers each day. And in "B" it auto-detects most occurring number in "A". And also in "B" it shows how much times most occurring number have occured.

But problem is that my MODE function is not working properly in "B", because You can see i have two times 189 and 188, but in "B" by mode it shows 188.

It's no problem when one number occurs more frequently than others, then MODE gives correct number in "B".

But problem starts when it's like some different numbers which are occurring same time, as you can see in my work. I have two times 188 and two times 189, but in "B" it gives that 188 has occured most times.
If there's thing like this I just want that MODE gives me out highest most occuring number in range.
Example - I've got numbers 188,189,188,189,188,190,190,189,190, i want to mode function put out the 190 number.

How should i modify my formula?

Thanks in advance :)

4 Replies





@Detlef Lewin 

Thank You, it works :)
What does MULT stands for?


MULT is part of the function name MODE.MULT.



Thank You again!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies