Combine COUNTIF & EXACT
"T. Valko" wrote...
....
And the IF(COUNTA(..) bit? Where did the OP ask for that?
Where did they say that they wouldn't have 3 empty cells?
And if they did have 3 empty cells, then none of them would be "os", "p" or
"x", so why, without reading the OP's mind (or believing you could), would
that not trigger a return value of 1?
|