相隔空白數 在A列 (10848)


E2=IF(A2="","",-LOOKUP(,-MATCH(1=1,A3:A$23<>"",{1,0}))-1)


另解=IF(A2="","",COUNTA(B3:B$199)-SUM(G3:G$199))


另解=IF(A2="","",LOOKUP(1,SUBTOTAL(3,OFFSET(A2,,{0,2},ROW($1:$66))))-1)


留言