Mar 20 2019 05:19 PM
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)
Thanks in advance :)
Mar 20 2019 05:47 PM
SolutionMar 21 2019 03:28 AM
Thank You, it works :)
What does MULT stands for?
Mar 21 2019 03:50 AM
Mar 20 2019 05:47 PM
Solution