转置非0 (12206)

M2:N13{=INDEX(A:A,SMALL(IF($C$2:$J$3>0,{2;3},99),ROW(A1)))&""

O2:O13{=IF(N2="","",INDEX($1:$1,RIGHT(SMALL(IF($C$2:$J$3>0,{200;300}+COLUMN(C:J)),ROW(B1)),2)))

P2:P13=IFERROR(VLOOKUP(M2,A:J,MATCH(O2,$1:$1,),),"")



留言