View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Knox Knox is offline
external usenet poster
 
Posts: 45
Default 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