need opposite of MODE function in Excel

[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.

 

[jaf]

Hi Kevin,
You can do that with the Frequency function.

data freq bins
2 0 1
4 3 2
5 0 3
2 2 4
4 1 5
2 0 6


Select b2:b7, click in the formula bar and enter =FREQUENCY(A2:A7,C2:C7)
When done use <ctl><sft><enter> to create an array formula.

The resuls are 1 occures 0 times, 2 occ. 3 times, 3 occ. 0 times, 4 occ. 2
times. etc.