or(exact)) function does not work
Hi
enter this as array formula (with CTRL+sHIFT+ENTER)
-----Original Message-----
Help!
I am trying to compare a list of words to an array of
words.
so example:
john to great
dog
john
To do this I am using the function
=or(exact(A1, B1:B3))
As told to do by help... but this does not work if the
word you are
searching for is not the first cell in the array.....
Please help on why this is.....
.
|