I am trying to compare two data ranges to determine if they are the same or not.
I'm using the following statement and I get a #Value! error message:
#Value!
=IF(SUM(ABS(B2:E7-G2:J7))=0,"Same", "Not")
Aucun commentaire:
Enregistrer un commentaire