K
Kevin
How do I find the number that occurs LEAST frequently in a range of
numbers? This is the exact opposite of the MODE function, which finds
the most common occurrence.
For example, a column of numbers contains;
2
4
5
2
4
2
MODE will return "2" as the most commonj occurrence. I want to know
that "5" is the least common occurence. Obviously, my column contains
many more numbers so it's not easily to simply visualize and count
them.
Is there a way to do this in Excel?
Thanks.
numbers? This is the exact opposite of the MODE function, which finds
the most common occurrence.
For example, a column of numbers contains;
2
4
5
2
4
2
MODE will return "2" as the most commonj occurrence. I want to know
that "5" is the least common occurence. Obviously, my column contains
many more numbers so it's not easily to simply visualize and count
them.
Is there a way to do this in Excel?
Thanks.