|
Posted to microsoft.public.excel.programming
|
|
|
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
|