T
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?
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?