27th February 2016, 05:53 PM
|
|
Member
|
|
Join Date: Nov 2013
Posts: 605
|
|
I hacked at your code and got the following, which appears to work:
Code:
=IF(A1="","",IF(A1="end","",COUNTIF(INDIRECT("b"&ROW(B1)&":b"&ROW(B1)+MATCH("?*",INDEX(A:A,1+MATCH(B1,A:A,0)):A$1048576,0)-1),"*")))
|