Need List C to = values in list A not in List B

[Ken Thompson]

I can get a list of values in Col A that are in Col B but not the opposite which is what I need.

I need to generate a list of the Values in Col A that do not show up in Col B. Seems simple as can be but I can't do it...

Help Please.

Thank You
-Ken

 

[HalfAce]

How about something like this in row 1 somewhere and copied down...

=IF(COUNTIF(B:B,A1)=0,A1,"")

(If that doesn't help then what are you using to get the list from col A that are in col B?)

Hope it helps.

 

[Ken Thompson]

I must be doing something wrong. It gives and error saying it creates a circular reference.

 

[Ken Thompson]

Oh and I didn't answer your question. Using Advanced Filter on Col A with Col B as criteria. Have tried <> in criteria but must have syntax wrong.

 

[Ken Thompson]

Aha! HalfAce, you're Total Ace in my book. It was a circular ref because some dummy put it in A1. I put it in F1 like a rational person would and it works perfect. Thanks So Much!

- Ken