compare data from one column with another and compare result to yet another

  • Thread starter Thread starter Matt Williamson
  • Start date Start date
M

Matt Williamson

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
 
easiest way is to use formulas

in B2 or another column in row 2

=if(Countif($D$2:$D$2735,A2)=0,If(Countif($C$2:$C$1056=0,"Not in B or
C","Not in B, in C"),"In B")

then drag fill down to 3793.
 
Back
Top