One way ..
Assuming data in row2 down
Place in C2: =ISNUMBER(MATCH(B2,A:A,0))
Copy down to the last row of data in col B
Then do an autofilter on col C, filter out FALSE
--
Max
Singapore
http://savefile.codm/projects/236895
xdemechanik
---
"zolabus" wrote:
Hi
i have two column with similar but not equal values
haw can i use vlookup to see wich elements of the B column are not in the A
column?
Thanks a lot