I have a data set in which I need to count the number of matches between any ID numbers in a column and equal ID numbers in a row. I have attached a data set example image and hopefully that will makes things a bit more clear.
I was looking to get help with a formula that would compute the values in Column
A (Row 2 and below).
The other columns are the pre-existing input data.
B is special; columns
E, ..., are all the same kind of data.
I want cell
An to count the number of matches between Column
B and Row
n, to the right of Column
A2 is 1 because
D2 (Row 2), and
A4 = 3 because Column
B and Row 4 have three matches:
I have tried a couple of different things like
but those don't seem to get at my problem.