A | B | |
1 | a | a |
2 | b | |
3 | a | |
4 | c | |
5 | a | |
6 | c | |
7 | b | |
8 | a | |
9 | ------ | ------ |
A | B | |
1 | a | a |
2 | ||
3 | b | |
4 | a | |
5 | c | |
6 | ||
7 | a | |
8 | c | |
9 | b | |
10 | ||
11 | a | |
12 | ------ |
works a treat thank you but how would i adapt to ignore blank cells?
Row\Col | A | B |
4 | a | 5 |
5 | b | 2 |
6 | a | MODE-LIST |
7 | c | a |
8 | a | b |
9 | c | |
10 | b | |
11 | a | |
12 | a | |
13 | b | |
14 | b | |
15 | d | |
16 | b | |
17 | ||
18 |
A | B | |
1 | E | A |
2 | C | B |
3 | ||
4 | A | |
5 | A | |
6 | ||
7 | D | |
8 | B | |
9 | B | |
10 | F | |
11 | ------ | ------ |