Compare two columns datas

  • Thread starter Thread starter Franck
  • Start date Start date
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.
 
=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)
 
Back
Top