How to Compare Lists of Data and Find Differences in Excel
Do you need to compare information in different lists? For example, you may need to find out which values exist in two lists and highlight differences.
There are several ways to compare two sheets or even workbooks in Excel. You can use functions like EXACT, IF, Lookup or Conditional Formatting to compare lists of data. In this blog, Happy’s trainers Sal and Ebbie will use Conditional Formatting to highlight values in one list that do not appear in another list.
