Find text
=--(countif(ae33:ak33,"*"&"v70.7"&"*")0)
or
=--(countif(ae33:ak33,"*v70.7*")0)
Will return true (if it's there) or false (if it's not).
beata wrote:
Hi. I'm trying to find the text "V70.7" within a particular range - and if I
find it? Great.
I'm able to look in one particular cell - for example:
=IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","")
but I'm trying to look in the range - and or the individual cells of AE33,
AF33, AG33 -- through to AK33
I've tried to use OR but I've overcomplicated it or I don't understand how
to use it.
thought?
--
Dave Peterson
|