Thank you sooooo much, You have just saved me hours of time! It works
magnificantly!

Keith

"Dave Peterson" wrote:

I think I'd just insert two columns--a new column B and a new column D.

Then in B1:
=if(isnumber(match(a1,c:c,0)),"In Column C","Missing from C")
and drag down

Then in D1:
=if(isnumber(match(c1,a:a,0)),"In Column A","Missing from A")
and drag down

Then I'd insert a new header row in row 1.
Select A:D
Data|filter|autofilter

Then I could filter to show the missing and copy those visible cells whereever I
wanted. (Yeah, I'd have to filter twice to get both columns.)

e Peterson