Need Basic Help on Data Filter/ Comparison

[cinglet]

I need some very basic help. I have two data sets that contain loan numbers. In Column A I have a list of autonomous loan numbers that do not repeat. In column B I have another list of loan numbers that are repeated multiple times throughout the column. I need to know what loan numbers in column A are not represented in column B?

Plesae help...
Thanks, Craig

 

[Oaktree]

Welcome to the board!

C1 = match(a1,b:b,0)

Copy down and filter (data --> filter --> autofilter) for #N/A