Simplifing a cell comparison check

[timmtamm]

There has to be a more simple way to check that these cells are equal to each other. It's a simple comparison really. I just need the left 6 to be equal to the right 6. Each left one must equal exactly the one on its right. Summing the 2 and then comparing the sum is not a proper solution.

Please Login or Register  to view this content.

[José Augusto]

Hi
Using a array formula (not tested)
=IF(AND(I7:I12=J7:J12),"Pass";"Fail")

[berlan]

One way,

=IF(SUMPRODUCT(--(I7:I12=J7:J12))=6,"Pass","Fail")

[berlan]

Or even better,

=IF(SUMPRODUCT(--(I7:I12<>J7:J12)),"Fail","Pass")

[timmtamm]

Thank you all.

All solutions seem to work (note: Jose's solution only works when set up as an array).

However, Berlan's second solution seems to be best.

Thanks

[berlan]

You're welcome, and thanks for the feedback and rep