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

¥X¶Ôªí³]©w¤T­Ó±ø¥ó·j´M®É¶¡¦p¦ó¼g

¥X¶Ôªí³]©w¤T­Ó±ø¥ó·j´M®É¶¡¦p¦ó¼g

¤½¥q¶R¤F·sªº¥X¶Ô¾÷­ì©l¸ê®Æ¬°¡i¥X¶Ô¸ê®Æ¡j¡A§Ú·Q¦b¡i¥X¶Ô°O¿ý¡j­«·s¾ã²z¤W¡B¤U¯Z®É¶¡­n¦p¦ó¼g?
¦pªþ¥ó
ÁÂÁÂ

¥X¶Ôªí.rar (5.96 KB)

C2:D53{=IFERROR(SMALL(IF((TRIM(¥X¶Ô¸ê®Æ!$A$2:$A$53)=$A2)*(INT(¥X¶Ô¸ê®Æ!$B$2:$B$53)=$B2),MOD(¥X¶Ô¸ê®Æ!$B$2:$B$53,1)),COLUMN(A1)),"")

TOP

¦^´_ 2# hcm19522


hcm19522¤j¤jÁÂÁ±zªº¦^ÂÐ
§Ú¶K¤W¨ç¼Æ±o¨ìªº®É¶¡¥þ³£¬O²Ä¤@µ§ªº¤W¯Z®É¶¡¡A
¤£ª¾§Ú¬O§_¦³­þ¸Ì¶K¿ù¤F¡A¯à§_¤W¶Ç±z­×§ï«áªºÀɮסC
ÁÂÁÂ

TOP

¦^´_ 3# caimy

"{" ¥Nªí shift+ctrl+enter ¤TÁä¤@°_«ö©Ò²£¥Í ,«Dµ{¦¡¸Ì­±

TOP

¦^´_ 4# hcm19522


    hcm19522¤j¤j¡A¨º­Ó§Ú¤@¶}©l´N¦³¸Õ¹L¦ýµ²ªG¦p¹Ï

TOP

¦^´_ 5# caimy

¤W­± "±`¥Î" §ï "¤½¦¡" ,³Ì¥kÃä "­«ºâ¿ï¶µ"¸Ì ,¤â°Ê§ï¦Û°Ê

TOP

¦^´_ 6# hcm19522


    hcm19522¤j¤j¡A¤½¦¡­«¦¡­ì©l¹w³]´N¬O¦Û°Ê

TOP

¦^´_ 7# caimy
http://www.FunP.Net/967315

TOP

¦^´_ 8# hcm19522


    ÁÂÁÂhcm19522¤j¤jªºÀɮסA
¥i¥H¨Ï¥Î¤F¡AÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD