matching pairs and removing unmatched (unique) values

[limeinside]

Hi,

Sorry if this is a really simple question, I just can't work it out.

I have a list of delegates who are registered for an event, each has a unique barcode.

When I scan their barcodes, I then have a list of who has attended (I only have the barcodes on this list, not their names etc). My problem is that I need to match the 2 lists and remove those who didn't attend from the list that contains their contact details.

In the past I have just sorted the barcode column and manually deleted those that didn't appear twice but this event is much larger so I need to learn a better way.

Any advice anyone can offer is much appreciated,

Thanks!

[djapigo]

Hi limeinside,

Check the attached spreadsheet... registered and attended list.xls

I used a simple VLOOKUP to see if a person attended... the VLOOKUP returns #N/A if not found, so I simply used an IF and ISNA formula to clean it up...

Use a filter on the Attended? column and you should get what you want.

Let me know if this doesn't work for you.

Later,
Dennis

[limeinside]

Dennis, thank you so much! This is exactly what I needed, I really appreciate it, thank you!

Lindsay