checking if two arrays are equal

[Guest]

I thought I could do an if statement with an array formula to check if two
columns of data are exactly even. For instance {=IF(A:A=B:B,"OK","NO")}, but
it gives an error value. Anyone know a way to do this? thank you

 

[Ardus Petus]

You may enter:
=A:A=B:B
and validate as Array formula
This will return FALSE or TRUE, which you can convert to NO/OK in another
cell

HTH

 

[bplumhoff]

Hello,

=SUMPRODUCT(--(R1:R1000=S1:S1000))=1000

HTH,
Bernd

 

[Guest]

awesome, thank you!

You may enter:
=A:A=B:B
and validate as Array formula
This will return FALSE or TRUE, which you can convert to NO/OK in another
cell

HTH