Posted on

Compare and highlight differences in Excel

Let’s say you have List A and List B, both starting in A2 and B2

In C2, enter this:

=IF(COUNTIF($B$2:$B$14, A2)=0, A2, "")

Drag-copy that down column C as far as needed.

If it appears in List A, but not in List B, it shows in Col C.