W1-A | 1 | 1 |
W1-A | 2 | 1 |
W1-A | 3 | 1 |
W1-A | 1 | 2 |
W1-A | 1 | 3 |
W1-A | 3 | 2 |
W1-A | 4 | 1 |
W1-A | 5 | 1 |
W1-A | 6 | 1 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
I am trying to create a formula for the 3rd column. The 3rd column counts the occurrences of the same combinations in the first two columns. For example, in row 4 the formula has recognised that 'W1-A' and '1' have occurred in columns 1 and 2 respectively for the 2nd time and it returns a count of 2 for the 3rd column. In row 5 it returns a '3' as that combination has now occurred 3 times.
Can anyone help with a formula that would be able to make these counts in column 3.
Thanks in advance.