Comparing Columns

[Pritish]

Hello,

I have two columns in my spreadsheet (Col A and Col B) which contains numeric values. I want to compare this two columns and find out the similar values.

For ex::
Col A Col B
111 222
222 444
333 111

In the above example, I want 111, 222 to be as my answer and that's what I want.
Please let me know if you want any more information about this problem.

Thanks in advance.

[pike]

so deduct ColARow1 value from ColBRow1 value then find the mode of results?

or can you provide more info

[davesexcel]

=COUNTIF($A$1:$A$3,B1)

Place this formula in C1 and drag it down, it will count the number of items column B has to column A