Previous Topic Next Topic

How to match 2 lists to get the unique entries

Closed
bettyindc Posts 1 Registration date Wednesday June 3, 2015 Status Member Last seen June 3, 2015 - Jun 3, 2015 at 02:01 PM
xpcman Posts 19528 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Jun 3, 2015 at 02:59 PM
I have two spreadsheets, one containing a complete list of titles in a database and the other containing a subset of that list. I want to find the entries from the complete list that are NOT in the subset list without having to check the lists manually. How can I do that?
Related:

1 response

Answer 1 / 1
xpcman Posts 19528 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,824
Jun 3, 2015 at 02:59 PM
Here is one way:

https://www.excel-easy.com/examples/compare-two-lists.html