a problem

B

bakalim

there is an A column has 1500 line

and a B column has 1700 line and B column already has A column entries,
there just 200 entries are different

i want to find 200 diffrent entries. how can i find?
 
B

Bob Phillips

Conditional formatting.

Select B1:B 1700.

Menu Format>Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of =ISNUMBER(MATCH(B1,$A:$A,0))
Click Format
Select the pattern tab
Choose a colour
OK
OK

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bob Phillips

I have just tried it and it worked, although I admit to get what you want
the formula should be

=NOT(ISNUMBER(MATCH(B1,$A:$A,0)))

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top