Hi there, iam trying to return the word interference if any cell on the range of G17:K26 contains the symbol >and next to the symbol is a value
For example, in cell G20 i have <5 it should return the word interference regardless the value next to the symbol, thanks in advance for any help.
where do you want this word? in one cell? and your examples differ you ask for > and < do you mean both?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Yea martinwilson need the word INTERFERENCE in one cell, let say, K12 and the symbol to use will allways be <, i use the symbol to identify that the competitor made an interference on that score, thanks for your response.
=IF(SUMPRODUCT(--ISNUMBER(--MID(G17:K25,FIND("<",G17:K25)+1,1))),"interference","")
assuming that the value is always a number
martindwilson, Thanks very much, it does work perfect, just what i needed, relly appreciated, Cheers!!Originally Posted by martindwilson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks