Using Excel to compare two datasets

When you have two datasets (lists) and you need to identify those items that appear in both lists, there are three different methods to acheive this. Here I demonstrate each one.