Comparing a range of values

[tamirh]

I want to compare two ranges of cells with each other. Some need a string
comparasion, and some need a floating point delta comparasion. So I was
trying to do something like this:

=AND( (A1:A10)=(B1:B10) )
=DELTA( (C1:C10), (D110) )

However I get back #VALUE when I try to do a range like that (it works if I
do just one cell). How would I compare all the values at the same time?

 

[T. Valko]

Assuming you want to compare A1 to B1, A2 to B2, A3 to B3, etc...

Array entered** :

=AND(A1:A10=B1:B10)
=AND(C1:C10=D110)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

DELTA won't work on arrays.

 

[tamirh]

Thanks, the CTRL+SHIFT+ENTER was what I was looking for.

 

[T. Valko]

You're welcome. Thanks for the feedback!