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

[µo°Ý] [µo°Ý] ¦p¦ó¨Ì·Ó¬YÄ檺§Ç¦¸¶i¦æ¿z¿ï¸ê®Æ

[µo°Ý] [µo°Ý] ¦p¦ó¨Ì·Ó¬YÄ檺§Ç¦¸¶i¦æ¿z¿ï¸ê®Æ

½Ð±Ð ¨Ï¥ÎVBA ¨Ì·Ó°h³f­ì¦](FÄæ)ªº¦¸§Ç¥h¿z¿ïD2:F14ªº¸ê®Æ,
¤]´N¬O¦P¼Ëªº"°h³f½s¸¹"¥u·|¯d¤U°h³f­ì¦]§Ç¦¸±Æ¦W³Ì«e­±¨º¤@µ§¸ê®Æ¡A¨ä¥Lªº¸ê®Æ³£§R±¼¡Cµ{¦¡­n¦p¦ó¼g?

°h³f¬ö¿ý.jpg (197.26 KB)

°h³f¬ö¿ý.jpg

°h³f¬ö¿ý.rar (10.23 KB)

{=IFERROR(INDEX(B:B,SMALL(IF(MATCH($B$3:$B$14&$D$3:$D$14,$B$3:$B$14&$D$3:$D$14,)=ROW($1:$12),ROW($3:$14)),ROW(A1))),"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD