Copy common number present in multiple rows

Hi all,

I am new to vba.
I need vba for following.
A & B column contains data. Each row in both column has one common number in either A column or B column.
I want to copy that number.

Example

A B
11 56

73 11

97 11

11 39

In above, 11 is common number. I want that number to be copied.
Please help.

Thanks in Advance

Hi nathansav,

Thanks a lot. It worked perfectly.

Hi nathansav,

Thanks a lot. It worked perfectly.

Hi nathansav,

The mode formula gives single common number present in all the rows.
What should I do, if I want another number which may also be common in some rows.
I mean next highest common number.

thanks