Thread: Excel formula help needed.
View Single Post
  #2  
Old 27th February 2016, 06:53 PM
walkermac walkermac is offline
Member
  
Join Date: Nov 2013
Posts: 603
Default
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),"*")))
Reply With Quote