Value from If & Countif formula

[edmund588]

Hi,

I have a problem in getting an If formula to return an X if a certain criteria is met. The formula should return an X only for *(A) *(B). I have attached a worksheet that should explain my problem clearer. The value I am referring to is in yellow.

Appreciate if anyone could kindly help.

Thanks

[Richard Buttrey]

Hi,

First remove all the ^ symbols from the 'blank' cells so that they are genuinely blank then:
in M4 copied down

Please Login or Register  to view this content.

[FDibbins]

ok, this got ugly, but it works lol....

=IF(M5=MID(M5,FIND("(",M5,1)-1,4)&" "&MID(M5,FIND("(",M5,FIND("(",M5,1)+1)-1,4)&" ","X","")

[jason.b75]

Maybe a simple solution

Please Login or Register  to view this content.

Also this maybe a little more efficient than repeated use of countif in column M, but it is limited, if a character repeats more than 9 times, it will fail.

Please Login or Register  to view this content.

[edmund588]

Richard Buttrey, FDibbins & jason.b75,

Thanks so much for the quick response. It's jason.b75 first formula is the one I exactly wanted. As for Richard's, it's similar to what I already have. Fdibbins's, slightly off the mark but definately will come in handy later.

Thanks again. Cheers