Assuming data in cols A and B from row1 down, and that what you want is to
extract the list of names within col A which are not found in col B

Put in C1:
=IF(A1="","",IF(ISNUMBER(MATCH(A1,B:B,0)),"",ROW() ))

Put in D1:
=IF(ROW()COUNT(C:C),"",INDEX(A:A,SMALL(C:C,ROW()) ))
Select C1:D1, copy down to the last row of data in col A
Col D returns the required listing, all neatly bunched at the top
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Webtek" wrote:
I'm looking for a comparison formula for text in two different columns. I
have two lists of names (A & B), and I want to generate a third list with the
names that are not on list B - Compare list A and list B. Help!?