Counting Duplicate cells in multiple columns

OK, I've looked high and low for an answer to this one and haven't found an answer I can use. I'm on Excel 2003 and have a sheet to track people who have read my emails. I want to know the answers to the questions below. I've included a fake sample to show what I'm looking at. The number of cells in each column is much higher and not the same per column. I've tried variations of MATCH, VLOOKUP, SUMPRODUCT, etc. but haven't found a good way to set up a formula.

1_______2_______3
Bob..... Fred......Harry
Fred.....Bob.......Tom
John.....Frank.....Fred
Bill.......Harry......Mike
Dave....Chris......Joe

How many matching names are in 1, 2 & 3?
How many matching names are in 1 & 2?
How many matching names are in 2 & 3?
How many matching names are in 1 & 3?

Any help would be greatly appreciated. Thanks in advance!