Three columns of names, find names that are not in all three?

[hoobajoob]

Hi all, trying to figure out the best formula to tackle this. Found a few that get me half way there, but not knowledgable enough to take it further. Bit of a noob when it comes to Excel so hoping someone can help with this :P

My problem is..
-I have three columns of names (A, B, C)
-Some names will be absent from one or more columns.
-These names do not match up in their row position.

What I need to output is
-Which name does not appear in all three columns
-Which columns do they not appear in

Any formulas to make this happen?

Cheers
Hooba

[twiggywales]

can you upload a work book to give a sample as this would make it easier

[twiggywales]

other questions are

will any 1 column have all the names (like a master list) will some of the names be missing from more then 1 column?