Least common numbers in range?

[malijela1]

Please, if anyone can help after searching the entire forum ...
I'm looking for a formula to find the least common numbers in range (in multiple columns!!!).
The table below is an example how I found most common numbers and I would like to see how can I find the least common numbers in a similar way.


[TABLE="width: 528"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD="colspan: 4"]most common numbers
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]F1[/TD]
[TD="colspan: 9"]MODE(IF(ISNA(MATCH($A1:$C10;$E1:E1;0));$A1:$C10))[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]G1[/TD]
[TD="colspan: 9"]MODE(IF(ISNA(MATCH($A1:$C10;$E1:F1;0));$A1:$C10))[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]H1[/TD]
[TD="colspan: 9"]MODE(IF(ISNA(MATCH($A1:$C10;$E1:G1;0));$A1:$C10))[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD]I1[/TD]
[TD="colspan: 9"]MODE(IF(ISNA(MATCH($A1:$C10;$E1:H1;0));$A1:$C10))[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]J1[/TD]
[TD="colspan: 9"]MODE(IF(ISNA(MATCH($A1:$C10;$E1:I1;0));$A1:$C10))[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]?
[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD][/TD]
[TD="colspan: 4"]least common numbers
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

How are you going to find the least common numbers when the example data you've supplied is composed entirely of the most common numbers?
Surely your data should include numbers other than 1 2 3 4 5 ?