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
--
AP

"Knox" a écrit dans le message de news:
...
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