comparing between different columns

  • Thread starter Thread starter jefe
  • Start date Start date
J

jefe

I am trying to look for duplicate entries when compared
between column A and column B. I can't seem to get it to
work. I have tried variations of the previous entry:

"one way is to use conditional formatting. Assume you
want to check column C. Select the whole column and
choose Format | Conditional Formatting ...

Change the Condition to "Formula is" and enter: =COUNTIF
(C:C,C1)>1 into the box. Change the font or the
background to a suitable highlight colour and press OK.

Wherever/whenever you have a duplicate entry it will
change colour"
 
That sounds familiar ...

Try it this way:

Select all of column A. Change the condition to "Formula is" and enter:
=A1=VLOOKUP(A1,$B:$B,1,FALSE) into the box. Change the font or the
background to a suitable highlight colour and press OK

Repeat for column B with =B1=VLOOKUP(B1,$A:$A,1,FALSE)

So entries in column A are highlighted if they appear in column B and vice
versa.

Does that work for you ?

Regards

Trevor
 
Hi
one way: if you want to copare column A and column B:
- select column A
- goto 'conditional format' and enter the formula:
=COUNTIF($B:$B,$A1)>=1
- choose your format

For column B enter the formula
=COUNTIF($A:$A,$B1)>=1
 
Yes that works nicely. Thank you very much.
-----Original Message-----
That sounds familiar ...

Try it this way:

Select all of column A. Change the condition to "Formula is" and enter:
=A1=VLOOKUP(A1,$B:$B,1,FALSE) into the box. Change the font or the
background to a suitable highlight colour and press OK

Repeat for column B with =B1=VLOOKUP(B1,$A:$A,1,FALSE)

So entries in column A are highlighted if they appear in column B and vice
versa.

Does that work for you ?

Regards

Trevor





.
Click to expand...
 
Back
Top