Guest List

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

Oh and by the way, if this can be done without using VBA all the better as I have no experience with this. I can however ead code being a PASCAL programmer many moons ago, so if the only way is with code, a little tip on how to paste it to a worksheet weould be good.
I have searched thorugh the site, and it seems that code is the way to go.. Arrgh,
at least it will force me to get to grips with it I suppose.

heres hoping that some bright spark can clear this up for me...

Respect

Mattman

Hi!

THe following put in col C will identify the non-members who bought drinks:

=IF(COUNTIF($B$2:$B$3,A2)=0,A2,"") where A2:A9 are the drinks bought and B2:B3 are the members.

All that remains then is to extract the unique names from col C. This can be done with Data > Filter > Advanced Filter using the option for unique values only and the option to paste the results "elsewhere".

So it can be done without VBA. Whether you want to will depend on your application.

Alf