Use the match function to determine if a particular entry is in a different
list. Ex: =isna(match(a2,Sheet2!a:a,false)) will return TRUE if the
contents of a2 do NOT appear in the list in column A of Sheet2. Autofill
that formula through column B, and do the same thing in the list on Sheet2,
referencing Sheet1. The turn on your autofilters and show only the TRUEs;
copy the remaining rows to wherever for further review.

"Tennessee" wrote:

Does anyone know how to set up a formula to compare two lists of mostly
similar entries and have Excel move or copy any non-repeating entries to a
new column [so that I can see them more easily]?