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

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" <Knox@discussions.microsoft.com> a écrit dans le message de news:
AEB153C3-EDBC-4652-A221-44999EC120C2@microsoft.com...
>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

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" <Knox@discussions.microsoft.com> a écrit dans le message de news:
> AEB153C3-EDBC-4652-A221-44999EC120C2@microsoft.com...
> >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
>
>
>

Hello,

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

HTH,
Bernd