Duplicate excel lists

Closed
misfitsmedia Posts 1 Registration date Monday April 13, 2015 Status Member Last seen April 13, 2015 - Apr 13, 2015 at 01:07 AM
I have two excel lists, one containing 10,000 members and one containing 12,000 members. How do I formulate a list of those members who only appear in the longer list?