My brief sample of the problem is as follows:
Column one Column two
1bc 560
3tr 1bc
4578 67
67 456
What i want to do is match each row in column one with column two and to return count for number rows that match. my summary sheet should look like
Count(reference numbers)
2 {2 should be returned for the sample above}
No duplicate values will exist as the each row is unique.
How go get to solve this?
Column one Column two
1bc 560
3tr 1bc
4578 67
67 456
What i want to do is match each row in column one with column two and to return count for number rows that match. my summary sheet should look like
Count(reference numbers)
2 {2 should be returned for the sample above}
No duplicate values will exist as the each row is unique.
How go get to solve this?
