I have two lists, List 1 ans List 2. I am looking to combine the 2 lists but also to delete any multiples between them. I have attached a file with the two lists. I am looking for either a formula or macro to do it. Preference is for a formula as long as it will not take to long to update when I refresh the file.
Thanks.
Bookmarks