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

[µo°Ý] ¦p¦ó±Æ°£ªÅ¥ÕÀx¦s®æ¬D¥X¨Ì§Ç±Æ¦C

[µo°Ý] ¦p¦ó±Æ°£ªÅ¥ÕÀx¦s®æ¬D¥X¨Ì§Ç±Æ¦C

¥ý¶i¡G
´£°Ý¡G¦p¦ó±N¥H¤U¤­Ä椤±Æ°£ªÅ¥ÕÀx¦s®æ¡A¨Ã¬D¥XÀx¦s®æ¦³¼Æ¦r¨Ì§Ç±Æ¦C¥X¦p¨D¸Ñ°Ïªºµ²ªG¡C

°ÝÃD32-±N¤u§@1¤¤¯S©wÄæ¦ì¬D¥X¸É»ô±Æ¦C.rar (36.62 KB)

§Æ±æ¤ä«ù!

¦^´_ 1# s7659109

¦b°ÝÃD¼W¥[»²§UÄæ: G3 =IF(COUNTIF(B3:F3,"")<5,ROW(),"")
¦b¨D¸Ñ¸ê®Æ§¨
¸ê®Æµ§¼ÆG2: COUNTIF(°ÝÃD!G:G,">0")
B2¤½¦¡©¹¥k©¹¤U©Ô
=IF(ROW(A1)>$G$2,"",IF(ISBLANK(INDEX(°ÝÃD!A:A,MATCH(SMALL(°ÝÃD!$G:$G,ROW(A1)),°ÝÃD!$G:$G,))),"",INDEX(°ÝÃD!A:A,MATCH(SMALL(°ÝÃD!$G:$G,ROW(A1)),°ÝÃD!$G:$G,))))

TOP

¦^´_ 2# samwang

¼W¥[ªþ¥óÀɮרѰѦÒ

°ÝÃD32-±N¤u§@1¤¤¯S©wÄæ¦ì¬D¥X¸É»ô±Æ¦C1.zip (69.53 KB)

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD