a problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bakalim - 09 Feb 2007 09:44 GMT

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?

Reply to this Message

Bob Phillips - 09 Feb 2007 10:11 GMT

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

Signature

HTH

Bob Phillips

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

> 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?

Reply to this Message

bakalim - 09 Feb 2007 13:26 GMT

THANK YOU BOB BUT THERE IS A PROBLEM MY FORMULA DID NOT WORK GIVING ERROR

"Bob Phillips" <bob.NGs@somewhere.com>, haber iletisinde þunlarý
yazdý:eccSmKDTHHA.3500@TK2MSFTNGP05.phx.gbl...

> Conditional formatting.
>
[quoted text clipped - 15 lines]
>>
>> i want to find 200 diffrent entries. how can i find?

Reply to this Message

Bob Phillips - 09 Feb 2007 14:55 GMT

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)))

Signature

HTH

Bob Phillips

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

> THANK YOU BOB BUT THERE IS A PROBLEM MY FORMULA DID NOT WORK GIVING ERROR
>
[quoted text clipped - 19 lines]
> >>
> >> i want to find 200 diffrent entries. how can i find?

Reply to this Message