種類聚集單格 依勾選 (13219)

G8:G13 (下拉完全 才正確)=IF(B8="V",IF(COUNTIF(B$8:B8,"V")=1,""," ,")&C8,"")&G9

G15:G20 (下拉完全 才正確)=IF(B15="V",IF(COUNTIF(B$15:B15,"V")=1,""," ,")&C15,"")&G16

D3:D4=VLOOKUP(LEFT(C3,2),A:G,7,)