Counting Duplicate cells in multiple columns

[dgcuk23]

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!

[NBVC]

How many what are in 1, 2, and 3?


To me it looks like the answer is always 3 from your sampleset.

[dgcuk23]

Sorry for any confusion. THe columns got lost when I posted so they may not be as clear. The names below "1" represent the people who read the first email.

In my example, Bob read the 1st and 2nd email, but Fred read all three. Harry only read the 2nd and 3rd. So I'm looking for workable formulas that will cross-reference each column and give me a total count of matches.

[NBVC]

See attached:

Formula for 1&2&3:

Please Login or Register  to view this content.

Formula for 1&2:

Please Login or Register  to view this content.

Formula for 2&3:

Please Login or Register  to view this content.

Formula for 1&3:

Please Login or Register  to view this content.

[dgcuk23]

That is awesome.

Now if I could get a bit greedy and ask for a little bit more help. If I wanted to find the people who only were in 1&2 (and not 3), would I simply subtract the 1&2 total from the 1,2&3 total? Or is there a different formula I would want to use?

[NBVC]

That would be something like this:

Please Login or Register  to view this content.

[dgcuk23]

Thanks. That's exactly what I was trying to figure out.

PS. Cute kid