compare function

[Cindy]

Hi,
I was wondering if someone could tell me if Excel can do the following:
Compare my 'A' list of club members (their names and phone numbers)
with my 'B' list of people (their names and phone numbers) and only output
the
names on the 'A' list who DO NOT appear on the 'B' list?
Thanks

 

[Cole]

hi

try
=if(match(listA!A1,listB!A:A)>0,"",A7)

match value of cell A1 in listA with Column A in list B and if true equal ""
or if false equal to the cell value
but this doesn't give you nice formated list

if you need to produce a nice formated list, you need to use Query or VBA to
produce it.

Good luck