countif

[jasman]

i the following formula how can i add the conditions that if the value in cell l7 is equal to value in cell r7 or u7 then read TRUE?

=NOT(IF(OR(COUNTIF(L7,F7&"*"),COUNTIF(L7,I7&"*")),OR(ISNUMBER(SEARCH({0,1,2,3,4,5,6,7,8,9},L7)))))

THANKS

 

[jasman]

ive found that these are thw 2 formulas i need but i need to join them together?

=NOT(IF(OR(COUNTIF(L7,F7&"*"),COUNTIF(L7,I7&"*")),OR(ISNUMBER(SEARCH({0,1,2,3,4,5,6,7,8,9},L7)))))

=IF(LEFT(R8,1)=L8,"TRUE", IF(LEFT(U8,1)=L8,"TRUE", "FALSE")),"FALSE")

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/showthread.php?t=551994&page=2

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.