Thread: Return Count for LAST NonBlank Cell in each Row
View Single Post
  #4   Report Post  
Aladin Akyurek
 
Posts: n/a
Default
=IF(COUNTIF(C5:L5,"x"),COLUMNS(C5:L5)-MATCH(2,1/(C5:L5="x")),0)

which needs to be confirmed with+control+enter.
Reply With QuoteReply With Quote