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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data from one excel to another 1
VBA Compare part of cell to another cell and then calculate 0
Macro that compares columns and identifies changes 11
Macro to compare columns and output the results 5
compare value of cell in one sheet to range of another sheet 3
Compare text in one column to another and return a value from another. 4
Macro for comparing columns and highlighting matching/differences 14
Compare blank cells in a column 6

Back
Top