找出組別 無編組二種處理 (13939)

I2無編組空白=INDEX($1:$1,TEXT(SUMPRODUCT((B$2:F$11=H2)*COLUMN(B:F)),"0;;99"))&""

加註無編組=IFERROR(INDEX($1:$1,TEXT(SUMPRODUCT((B$2:F$11=H2)*COLUMN(B:F)),"0;;")),"無編組")

加註無編組{=IFERROR(INDEX($1:$1,LARGE(IF(B$2:F$11=H2,COLUMN(B:F)),1)),"無編組")