I know that to delete duplicates in a spreadsheet I use Advance Filter-unique
records only. However, some of the lists I use requires that both of the
items in that list need to be deleted.
For instance, I have a list of all our patrons. We have a separate list of
patrons that already purchased tickets to the next performance. We need to
send an invitation to our patrons to attend this performance. Obviously, we
don't want to send invitations to those who have already purchased tickets to
this.
Is there a way to do this other than manually deleting both entries?