Compare 2 lists in Excel

0:00 Intro
1:22 Scenario 1, merging 2 lists and removing all duplicates to leave unique entries.
7:31 Scenario 1, here we have 2 separate lists of students with different test results and we want to compare the results from both sheets, only for the students that exist in both lists.

Tutorials referred to in this video:

Lookup Functions
https://youtu.be/qgankq3WqAE

Relative, Mixed and Absolute References
https://youtu.be/qgankq3WqAE

Conditional Formatting
https://youtu.be/fhROKb_FoC8

Видео Compare 2 lists in Excel канала Nicos Paphitis