Hello

If your list in column A is from A1 to say A6 and list in B is from B1:B6
then enter the following in C1 and copy it down to C6

=IF(COUNTIF($B$1:$B$6,A1)0,"",A1)

Alok

"Jim Bancroft" wrote:

Hi everyone,

I have two columns of strings, both in ascending order. Similar lists but
not identical. Are there macros or other steps I can take to compare column
A with column B, so that all entries in A that aren't in B wind up in column
C? Thanks!