Formulae needed

[Graham]

Hi
I have colmn A with 100 chassis numbers and Colmn B with 85 chassis numbers,
Column B is 15 chassis numbers short of column A ( all column B hassis
numbers are in column A as well ), is there a formulae I can use to extract
these 15 chassis numbers from "A"

 

[Bernie Deitrick]

Graham,

In column C, use a formula like this (entered in C2)

=ISERROR(MATCH(A2,B:B,FALSE))

and copy down, then sort or filter on column C and select the values in A where the value in C is
TRUE.

HTH,
Bernie
MS Excel MVP