Hi, my problem is this

In column A I have a list of names, and in column B I have a list of members,
The names list shows a persons name each time they buy a drink, so:

A
Jim
Fred
Fred
Fred
Jim
Alice
Jayne
Alice

B
Jim
Jayne

Now what I want is to list people who bought a drink, but are not members without repeating names so in this case the result would be

C
Fred
Alice

Hope I have explained myself well enough, and look forward to your replies

regards

Mattman