上級名稱 依職位 (11693)

G2:G20{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(B$2:D$13<>"",ROW($2:$13)/1%+{2,3,4}*10001),ROW(A1)),4),"!R0C00"),),"")

H2:H20{=IF(G2="","",LOOKUP("嫻",OFFSET(A$2,,SUM((B$2:D$13=G2)*{1,2,3})-1,SUM((B$2:D$13=G2)*ROW($2:$13))-1)))