I have a range of B2:U18 in these cell I input a number
At the bottom in row 21 I have countif counting the different numbers
Now in row 24 I would like it to tell me what numbers have a counting value of 0
And in row 26 I would like it to tell me what numbers I have the most of
I had a formula for row 24 in another file but when I tried to rewrite for this file it didn't work
It got me thinking if it could tell me what I have the less of could it tell me what I have the most of
it would make my job easier and faster
<tbody>
</tbody>
At the bottom in row 21 I have countif counting the different numbers
Now in row 24 I would like it to tell me what numbers have a counting value of 0
And in row 26 I would like it to tell me what numbers I have the most of
I had a formula for row 24 in another file but when I tried to rewrite for this file it didn't work
It got me thinking if it could tell me what I have the less of could it tell me what I have the most of
it would make my job easier and faster
1 | 3 | 4 | 5 | 6 | 8 | 9 | 1 | 4 | 5 | 6 | 8 | 9 | 1 | |||||||
10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | |||||||||||
3 | 4 | 5 | 6 | 8 | 9 | 1 | 5 | 6 | 8 | 9 | 1 | |||||||||
18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 20 | |||||||||||
5 | 8 | 9 | 1 | 8 | 9 | 1 | ||||||||||||||
19 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | |||||||||||
8 | 9 | 1 | 9 | 1 | ||||||||||||||||
18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 11 | |||||||||||
1 | 3 | 4 | 5 | 6 | 8 | 9 | 1 | 4 | 5 | 6 | 8 | 9 | ||||||||
19 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | |||||||||||
1 | 5 | 6 | 8 | 9 | 1 | 6 | 8 | 9 | 1 | |||||||||||
20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | |||||||||||
8 | 9 | 1 | 9 | 1 | ||||||||||||||||
19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | |||||||||||
1 | 3 | 4 | 5 | 6 | 8 | 9 | 1 | 4 | 5 | 6 | ||||||||||
20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | |||||||||||
8 | 9 | 1 | 5 | 6 | 8 | 9 | 1 | 5 | 6 | 8 | ||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | |
20 | 0 | 4 | 7 | 12 | 12 | 0 | 0 | 17 | 4 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 5 | |
Missing Items | ||||||||||||||||||||
Most Items | ||||||||||||||||||||
<tbody>
</tbody>