mycmyc

¦^´_ 10# mycmyc


    ¤£¦n·N«ä   ¦A½Ð°Ý ¨Ì¤é´ÁÄæ ¨ú¦^ ·í¤é¤£¬°0ªº¤u§@¤º®e   ¦p¬õ¦â¤§¤å¦r  ÁÂÁ±z
¦A½Ð±Ð-1104.rar (10.99 KB)

¤U¸ü¦¸¼Æ: 5

2018-11-4 13:18

n7822123

¦^´_ 10# mycmyc


·Ç¤j¼gªº§ó²³æ¤@¨Ç!

mycmyc

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

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

­ã´£³¡ªL

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

mycmyc

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

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

¦^´_ 2# n7822123




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

¤U¸ü¦¸¼Æ: 3

2018-11-2 18:12

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

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

hcm19522

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