Matching Entries of Two Column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mazalam - 01 Sep 2005 13:37 GMT

Column A has 962 entries. Column C has 898 entries. I want to find out,
in Column B, entries that are in column A but not in Column C.

Thanks in advance.
Mazhar

Signature

mazalam

Reply to this Message

Bob Phillips - 01 Sep 2005 14:26 GMT

in d1

=IF(COUNTIF(C:C,A1)=0,"Not found","")

and copy down

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> Column A has 962 entries. Column C has 898 entries. I want to find out,
> in Column B, entries that are in column A but not in Column C.
>
> Thanks in advance.
> Mazhar

Reply to this Message