I'm not real sure how to go about doing this.

I need to compare one column (ALL - a2:a3793) to see if it has any numbers
that are not in another column (ALL AFTER CHG - d2:d2735). Then take the
results of that and compare them to another column. (INACTIVE c2:c1056) All
of the columns are formatted as text. What is the most efficient way to do
this?

TIA

Matt