Hsieh

¦^´_ 4# shootingstar


    M2°}¦C¤½¦¡
=IF(ROW($A1)>COUNTA(OFFSET($A$1,1,MATCH($L$2,$1:$1,0)-1,COUNT($A:$A),1)),"",SMALL(IF(OFFSET($A$1,1,MATCH($L$2,$1:$1,0)-1,COUNT($A:$A),1)<>"",OFFSET($A$1,1,,COUNT($A:$A),1),""),ROW($A1)))

N2¤½¦¡
=IF($M2<>"",OFFSET($A$1,MATCH($M2,$A:$A,0)-1,MATCH($L$2,$1:$1,0)-1),"")
¥X®u¤é´Á.zip (7.81 KB)

¤U¸ü¦¸¼Æ: 3

2019-1-29 17:31