Compare two columns datas

F

Franck

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.
 
B

Bob Phillips

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