View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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?