ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

½Ð±Ð
½Ð±Ð.rar (7.89 KB) §Ú·Q§ä¥X  ¿B¤ôÂßÅé¼ÒªO  ¦³¬I¤uªº¤é´Á ­n¦p¦ó¹F¦¨©O ÁÂÁÂ
HI

¥»©«³Ì«á¥Ñ n7822123 ©ó 2018-11-2 01:34 ½s¿è

¦^´_ 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

½Ð±Ð+.png
2018-11-2 01:25


½Ð±Ð.rar (18.65 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

{=IFERROR(SMALL(IF((B$1:H$1=K$8)*(B$6:H$30>0),A$6:A$30),ROW(A1)),"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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

TOP

¦^´_ 4# mycmyc

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

TOP

¦^´_ 2# n7822123




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

TOP

¦^´_ 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)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

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

TOP

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

TOP

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

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

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD