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.
<tbody>
</tbody>
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.
A | B | C | D | E | F | G | H | I | J | ||||||
1 | 1 | 2 | 2 | 2 | 5 | 1 | 3 | 4 | most common numbers | ||||||
2 | 5 | 3 | 3 | ||||||||||||
3 | 2 | 4 | 4 | F1 | MODE(IF(ISNA(MATCH($A1:$C10;$E1:E1;0));$A1:$C10)) | ||||||||||
4 | 4 | 5 | 2 | G1 | MODE(IF(ISNA(MATCH($A1:$C10;$E1:F1;0));$A1:$C10)) | ||||||||||
5 | 2 | 1 | 1 | H1 | MODE(IF(ISNA(MATCH($A1:$C10;$E1:G1;0));$A1:$C10)) | ||||||||||
6 | 3 | 2 | 5 | I1 | MODE(IF(ISNA(MATCH($A1:$C10;$E1:H1;0));$A1:$C10)) | ||||||||||
7 | 5 | 4 | 2 | J1 | MODE(IF(ISNA(MATCH($A1:$C10;$E1:I1;0));$A1:$C10)) | ||||||||||
8 | 2 | 3 | 1 | ||||||||||||
9 | 3 | 5 | 5 | ||||||||||||
10 | 1 | 2 | 4 | ? | ? | ? | ? | ? | least common numbers |
<tbody>
</tbody>