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

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

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

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.

--
Regards,
Tom Ogilvy

"Matt Williamson" wrote in message
...
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