checking if two arrays are equal
 

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

checking if two arrays are equal
 

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

checking if two arrays are equal
 

Hello,

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

HTH,
Bernd

checking if two arrays are equal
 

awesome, thank you!

"Ardus Petus" wrote:

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