Column Comparison - Missing Values

[Kevin]

After combining two worksheets, I have two columns that are supposed to be
identical, but are not.
Starting from row 2, column D has 7209 numeric entries, while column E has
7214.

How can I identify what values do not match up.

Thanks for saving me from scolling. I could do that once but this will be
an ongoing issue. Also, please I am not a programmer but do have a knowledge
of functions.

 

[Gaurav]

in F2, type =EXACT(D2,E2) and drag it down.

Or

Select E2 > go to Format > Conditional Formatting >select Cell Value Is