“I need to compare 2 lists”. This is something that comes up regularly in my Excel training sessions. “I need to know which items in list 1 also exist in list 2”
Whether it’s a list of names or email addresses or ID’s, It doesn’t really matter.
The process is the same. There’s a few ways you can do this and in this video I’ll show you what I think is the simplest way
Download a copy of the file(s) used in this video: https://share.zight.com/4gup8b6n