½Ð±Ð·j´M¦WºÙ¡@§ä¥X¤é´Á¡@ÁÂÁÂ

mycmyc

½Ð±Ð
½Ð±Ð.rar (7.89 KB)

¤U¸ü¦¸¼Æ: 10

2018-11-1 19:34

§Ú·Q§ä¥X  ¿B¤ôÂßÅé¼ÒªO  ¦³¬I¤uªº¤é´Á ­n¦p¦ó¹F¦¨©O ÁÂÁÂ

n7822123

¦^´_ 1# mycmyc


J4¡G¿é¤J§A­nªº¤uµ{¦WºÙ
J6~J100¡G=IFERROR(SMALL(IF(HLOOKUP($J$4,$A$1:$H$100,ROW(),FALSE)="","",$A$6:$A$100),ROW()-5),"")

Ctrl+Shift+Enter

¤U¸ü (5.08 KB)

2018-11-2 01:25

½Ð±Ð.rar (18.65 KB)

¤U¸ü¦¸¼Æ: 6

2018-11-2 01:25

hcm19522

{=IFERROR(SMALL(IF((B$1:H$1=K$8)*(B$6:H$30>0),A$6:A$30),ROW(A1)),"")

mycmyc

ÁÂÁ ¤G¦ì«e½ú«ü¾É  §Ú¸Õ¸Õ¬Ý ¦³°ÝÃD¦A½Ð±Ð³á

mycmyc

¦^´_ 4# mycmyc

¦A½Ð±Ð«e½ú §Ú·Q¦A®³¥X ´M§ä¨ì¤é´Á«á §ä¥X ¸Ó¤é´Á¼Æ¶q
³Â·Ð «e½ú«ü±Ð ½Ð±Ð-1.rar (12.06 KB)

¤U¸ü¦¸¼Æ: 1

2018-11-2 18:07

mycmyc

¦^´_ 2# n7822123




¦A½Ð±Ð«e½ú §Ú·Q¦A®³¥X ´M§ä¨ì¤é´Á«á §ä¥X ¸Ó¤é´Á¼Æ¶q
³Â·Ð «e½ú«ü±Ð    ½Ð±Ð-1.rar (12.06 KB)

¤U¸ü¦¸¼Æ: 3

2018-11-2 18:12

n7822123

¦^´_ 6# mycmyc


K6¡G
IFERROR(INDEX($A$1:$H$100,MATCH($J6,$A$1:$A$100,0),MATCH($J$4,$A$1:$H$1,0)),"")

¤U©Ô

½Ð±Ð-1102.rar (22.04 KB)

¤U¸ü¦¸¼Æ: 5

2018-11-2 22:34

mycmyc

¦^´_ 7# n7822123
ÁÂÁ ªüÀs «e½ú«ü¾É
§Ú¥ý¸Õ¸Õ¬Ý³á
ÁÂÁ§A

­ã´£³¡ªL

K6:
=IFERROR(VLOOKUP(J6,A:H,MATCH(J$4,A$1:H$1,),),"")

mycmyc

¦^´_ 9# ­ã´£³¡ªL

    Æg!!
    ÁÂÁ§A §Ú¸Õ¸Õ³á