Hello all,
I've rows with some numbers in it. like this
I want to find which number has made the maximum number of appearances for each row. For the first row 15 has appeared 4 times.
Thanks for your help.
I've rows with some numbers in it. like this
Book2 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |||
1 | S1 | S2 | S3 | S4 | S5 | S6 | S7 | S8 | S9 | S10 | S11 | S12 | S13 | S14 | S15 | S16 | S17 | S18 | S19 | S20 | ||
2 | 15 | 15 | 7 | 4 | 8 | 18 | 0 | 4 | 13 | 5 | 15 | 7 | 10 | 14 | 14 | 11 | 1 | 15 | 14 | 8 | ||
3 | 1 | 1 | 0 | 18 | 3 | 0 | 3 | 16 | 9 | 12 | 1 | 0 | 17 | 18 | 8 | 10 | 15 | 4 | 2 | 11 | ||
4 | 1 | 8 | 15 | 9 | 1 | 6 | 0 | 8 | 10 | 8 | 6 | 8 | 6 | 1 | 4 | 5 | 2 | 18 | 0 | 2 | ||
5 | 17 | 4 | 5 | 11 | 14 | 0 | 7 | 16 | 11 | 13 | 6 | 17 | 18 | 9 | 8 | 15 | 3 | 16 | 7 | 9 | ||
Sheet1 |
I want to find which number has made the maximum number of appearances for each row. For the first row 15 has appeared 4 times.
Thanks for your help.