Compare two columns datas

Hi,
Lookin for an easy way to tell TRUE if two columns values are EXACTLY
the same (same row, same value) and FALSE if not...

Is there an Excel function to do that ?
Or will I have to check every cell (if A1=B1, A2= B2,....)

thks for help.

=SUMPRODUCT(--(A1:A100<>""),--(A1:A100=B1:B100))=MAX(COUNTA(A1:A100),COUNTA(
B1:B100))

--

HTH

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


"Franck" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> Lookin for an easy way to tell TRUE if two columns values are EXACTLY
> the same (same row, same value) and FALSE if not...
>
> Is there an Excel function to do that ?
> Or will I have to check every cell (if A1=B1, A2= B2,....)
>
> thks for help.
>