I have two sheets that contain mostly identical names but a few names with no match on the other sheet. For example:
Sheet 1
1. Kumar
2. Rajiv
3. Ranjith
4. Supriya
5. Sanjay
Sheet 2
1. Kumar
2. Rajiv
3. Ranjith
4. Hari
5. Sanjay
6. Supriya
I need to identify Hari
as not having a match on Sheet 1.
How can I identify such names that appear on Sheet 2 but not on Sheet 1?