• 460K Members
• 10.3K Online
• 558K Conversations
SOLVED

Highest most occurring number in range.

Occasional Contributor

Highest most occurring number in range.

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?
=MODE(B2:B32)

4 Replies
Highlighted
Solution

Re: Highest most occurring number in range.

`=MAX(MODE.MULT(B2:B13))`

Re: Highest most occurring number in range.

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

Re: Highest most occurring number in range.

MULT is part of the function name MODE.MULT.

Re: Highest most occurring number in range.

Thank You again!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies