按“工序”排序下来，取出对应的“姓名”及”数量“ 请大家帮帮忙哦

十里眼

公式看有没有简单点的哦
按“工序”排序下来，取出对应的“姓名”及”数量“  请大家帮帮忙哦

良良

C15=IFERROR(INDEX(B:B,INT(RIGHT(SMALL(IF(C$2:O$11<>"",ROW($2:$11)/1%+COLUMN(C:O)*10001),ROW(A1)),4)/100)),"")
D15=IFERROR(INDEX(MID(C$1:O$1,FIND("-",C$1:O$1)+1,99),RIGHT(SMALL(IF(C$2:O$11<>"",ROW($2:$11)/1%+COLUMN(A:M)*10001),ROW(A1)),2)),"")
E15=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(C$2:O$11<>"",ROW($2:$11)/1%+COLUMN(C:O)*10001),ROW(A1)),4),"r0c00"),),"")
均为数组三键。

十里眼

良良 发表于 2023-8-6 17:25
C15=IFERROR(INDEX(B:B,INT(RIGHT(SMALL(IF(C$2:O$11"",ROW($2:$11)/1%+COLUMN(C:O)*10001),ROW(A1)),4)/10 ...

大神，还有没有简单点的