Check for exceptions

  • Thread starter Thread starter Daniel Louwrens
  • Start date Start date
D

Daniel Louwrens

I am using Excel 2000 SP3

Is there a way to compare two columns of text to make sure that everything
in the one column is also in the other

thanks

Daniel
 
Assuming that your first column starts at A1 and your second column at B1,
you can put this formula in C1 and copy down:

=A1=B1

Then the ones that match will be evaluated as TRUE and the ones that don't
as FALSE.

Hope this helps!
 
Excellent

thanks for your help

regards

Daniel
Domenic said:
Assuming that your first column starts at A1 and your second column at B1,
you can put this formula in C1 and copy down:

=A1=B1

Then the ones that match will be evaluated as TRUE and the ones that don't
as FALSE.

Hope this helps!
Click to expand...
 
Excellent

thanks for your help

regards
Click to expand...

You're welcome! Oh, and of course, once you've done that, you can use
AutoFilter to get a list of only those that don't match so that you can take
a closer look.

Cheers!
 
Daniel Louwrens said:
Is there a way to compare two columns of text to make sure that
everything in the one column is also in the other
Click to expand...

If the two columns should be identical in terms of the order of the entries,
then you have an answer. If the two columns' entries could be in different
order, then that approach won't work. You'd need something like the array
formula

=AND((COUNTIF(RngA,"<"&RngA)=COUNTIF(RngB,"<"&RngA))
*(COUNTIF(RngA,"<"&RngB)=COUNTIF(RngB,"<"&RngB))
*COUNTIF(RngA,RngB)*COUNTIF(RngB,RngA))
 
Yes

that is the one, I can use the first one too on
another spreadsheet.

thanks

Daniel
 
Back
Top