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

[µo°Ý] ±a¤J²Å¦X¦h¶µ±ø¥ó«áªº¼Æ­È

[µo°Ý] ±a¤J²Å¦X¦h¶µ±ø¥ó«áªº¼Æ­È

½Ð°Ýª©¤W¦U¦ì¤j¤j
·Q­n¦bTESTªº¤u§@ªí¤¤,¦Û°Ê±a¤JDATA¤u§@ªí¤¤²Å¦X¦h¶µ±ø¥óªº¼Æ­È,
Àx¦s®æC3¤¤¸ÕµÛ¥Î¤U¦Cªº¤½¦¡¨S¿ìªk±N¼Æ­È±a¤J,½Ð¦U¦ì«üÂI¤@¤U,ÁÂÁÂ!!
=IFERROR(INDEX(data!$C:$C,MATCH($A3&$B3&$C2,data!$B:$C,)+COLUMN(C3)),"0")


LISTªí®æ.zip (96.14 KB)

C3:F8{=IFERROR(INDEX(data!$C:$C,MATCH(1=1,LOOKUP("¼_",$A$3:$A3)&$B3=data!$C$8:$C$99&data!$C$4:$C$95,)+CHOOSE(COLUMN(A1),8,10,11,12)),"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

C3/°}¦C¤½¦¡:
=iferror(INDEX(data!$C:$C,MATCH($B3&$A2&$A3,data!$C$1:$C$299&data!$C$5:$C$299,)+COLUMN(A$1)+5-($C$2=C$2)),"")

TOP

¦^´_ 3# ­ã´£³¡ªL ªO¤j
¸Õ¤F¤@¤U,µo²{­ÈÁÙ¬OµLªk±a¥X,­×§ï¤F°Ñ·ÓªºÀx¦s®æ,ÁÙ¬OµLªk±N­È±a¥X



   

TOP

¦^´_ 2# hcm19522
H¤j,
¼Æ­ÈÁÙ¬OµLªk±a¥X,¬O§Ú­þ¸Ì¦³§Ë¿ù¶Ü?

TOP

¦^´_ 5# ken88y


    ¼Æ²Õ¤½¦¡ :½Æ»s¤½¦¡ ¤£§t "=" ,¶K¤W«á¥[ "="   ;³Ì«e "{" ¥Nªí shift+ctrl+enter ¤TÁä¤@°_«ö©Ò²£¥Í ,«Dµ{¦¡¸Ì­±
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 5# ken88y


    A:A Äæ­^¤å¦r¥´¿ù¤F TSET1 §ï¬° TEST1¡A2 3 ¤@¼Ë
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2019-4-22 14:13 ½s¿è

C3:F4 °Ï°ì°}¦C

¥ý¿ï¾Ü C3:F4 Àx¦s®æ2X4®æ¡A½s¿èÄæ¶K¤W¤½¦¡¡A°}¦C¤½¦¡¤TÁä¿é¤J(¥ý«ö¦í CTRL+SHIFT¤£©ñ¡A¦A«öENTER¿é¤J¤½¦¡)
=IFERROR(INDEX(data!C:C,MATCH(A3&IF({1;0},B3,B4),data!C$8:C$98&data!C$4:C$94,)+7+{1,3,4,5}),"")

¿ï¾Ü C3:F4 Àx¦s®æ2X4®æ¡A¥k¤U¶ÂÂI¤U©Ô½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# ML089 ¦^´_ ­ã´£³¡ªL ªO¤j
¦^´_ hcm19522
¥i¥H±a¤J¼Æ­È¤F,¦hÁ¤T¦ìªº«ü¾É.

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD