i am trying to count the number of matching pairs of values in two columns.
eg:
Column A Column B
1910 760
1910 810
1910 810
1990 760
1990 760
the outcome of the above that i am looking for is as follows
1910 x 760 = 1
1910 x 810 = 2
1990 x 760 = 2
can someone please help me with a formula that will give me these count summaries?
Regards