Hi

I have the following problem:

I have to collums A and B and want a formula for collum C. In collum A and B I have a lot of rows with uniqe numbers in them. I need to see if there is to numbers that are the same, and how many numbers are the same?

Exampel:
A: B: C:
Number(1): Number(2): Match:
46 56 0
77 43 0
66 77 1
35 93 0
27 35 1
total:2

I have tried "if" funktions but not with any luck.

Please help me.....thanks!