advanced filter for two uneven columns

I've got two columns of text phrases. Attached is an example.

I want to find out which text phrases in column 1 are found in column 2. (exact match).

My procedure is:

(a) highlight cells A1 through C801
(b) click "advanced filter"
(c) click "copy to another location"
(d) List range shows as $A$1:$C:$801
(e) Criteria Range is $A$1:$A$479
(f) Copy to $C$1:$C$801
(g) Unique Records Only

Then when I run the filter, nothing happens. What am I doing wrong?

Thanks!

Hey Jrtaylor;

Unfortunately, I cannot help you with using the filter to determine the which are similar, however, I have an alternative.

=IF(ISERROR(MATCH(B2,$A$2:$A$479,0)),"No Match","Matched")

Given what you're looking for, to identify common keywords from Column B in Column A, that equation will prompt a simple "Match" if it matches something in Column A, or "No Match" if it's unique.

It's things like this that make me love excel... I'm sure it's possible to use a filter to find the unique records, but there are always a hundred different ways you can actually do what you're looking to do.