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

[µo°Ý] ¹B°Ê·|¹wÁÉÀË¿ýªíÅܦ¨¨MÁÉÀË¿ýªí

[µo°Ý] ¹B°Ê·|¹wÁÉÀË¿ýªíÅܦ¨¨MÁÉÀË¿ýªí

¤£¤~¦b¤U¦³¤S°ÝÃD¤F¡A·Q½Ð°Ý¦U¦ì°ª¤â¡A
¹wÁɾǥͤÀ¬°¤T²Õ¡A¦W³æ¡B¦¨ÁZ¦pªþÀÉ
¨C²Õ¨ú¤G¦W¡A¦A¥Ñ¤T²Õ¤¤¿ï¸û¨Îªº¤G­Ó¦W¦¸¡A¦@¨ú¤K¦W¾Ç¥Í¶i¤J¨MÁÉ¡A
½Ð°Ý¡G­n«ç»ò¦b¨MÁÉªí¤¤¶À¦â°Ï¶ô¤¤¼g¤½¦¡©O¡H
¥t¥~¡A¸É¥R»¡©ú¤@¤U¡G¦b¨MÁɪº¶]¹D¬O«ö¹wÁɦ¨ÁZ¨M©w¡A
¹wÁɲĤ@¦W¦b¨MÁɮɶ]²Ä¥|¹D¡A²Ä¤G¦W¶]²Ä¤­¹D¡A²Ä¤T¦W¶]²Ä¤T¹D¡K¡K(¦p¨MÁɪíÂŦâ°Ï¶ô)
¦]¤ñÁɶµ¥Ø²³¦h¡A§Æ±æ¦U¦ì¯à¬°À°¤@¤U¤p§Ì¡A·PÁ¡I

¹wÁɦ¨ÁZÂàÅܦ¨¨MÁɹD¦¸ÀÉ®×.zip (17.96 KB)

~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

¥H¤U³£¬O°}¦C¤½¦¡¡A¿é¤J§¹¦A¤U©Ô
H4=SMALL(IF(LEFT(¤k60M¹wÁɪí!$B$3B$38,4)=LEFT(A4,4),¤k60M¹wÁɪí!$H$3H$38,""),E4)
B4=INDEX(¤k60M¹wÁɪí!$CC,SMALL(IF(¤k60M¹wÁɪí!$H$3H$38=H4,ROW(¤k60M¹wÁɪí!$H$3H$38),FALSE),1))
C4=INDEX(¤k60M¹wÁɪí!$DD,SMALL(IF(¤k60M¹wÁɪí!$H$3H$38=H4,ROW(¤k60M¹wÁɪí!$H$3H$38),FALSE),1))

TOP

¥»©«³Ì«á¥Ñ ymes ©ó 2014-11-25 14:05 ½s¿è

·PÁ samwang ¤j¤jªºÀ°¦£¡A¦ý¸Ì­±¦³­Ó±ø¥ó¡A¥i¯à¤j¤j±z¨Sª`·N¨ì

¤j¤j±zªº¤èªk¬O¿ï«e¤K¦W¡A¦ý¦³®É¦³¹ê¤O¤£¥Nªí·|³Q¿ï¤W¡A§Úªº±ø¥ó¬O¡G

¤T²Õªº«e¤G¦W«O»Ù¶i¤J¨MÁÉ¡A³Ñ¤G­Ó¦WÃB¦A¥Ñ¤T²Õ¤¤¸û¨Îªº¤G­Ó¿ï¤J

¥i¥H¦AÀ°§Ú·Q¤@¤U¶Ü¡H·PÁ¡I
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_ 3# ymes

¹ï¤£°_¨S¦³¦Ò¼{¨ì¡A§ó·sÀɮצpªþ¥ó

¹wÁɦ¨ÁZÂàÅܦ¨¨MÁɹD¦¸ÀÉ®×1.zip (19.5 KB)

§ó·s

TOP

¥»©«³Ì«á¥Ñ ymes ©ó 2014-11-26 19:05 ½s¿è

¦A¦¸·PÁ samwang ªº¸Ñµª¡A¦ý»À¤HÁÙ¦³­Ó±ø¥ó¡A¤j¤j¥i¯à¥¼¯à¦Ò¼{¨ì
¶i¤J¨MÁɪº¿ï¤â¦¨ÁZ¡A­n«öÂŦâ°Ï¶ô±Æ¦W°µ±Æ§Ç¡A
¤j¤j¬O±N¤T²Õ«e¤G¦W±Æ¨ì«e¤»¦W¥h¤F¡A¦ý¾ÜÀuªº¤G¦ì¶]ªÌ¥¼¥²¬O¹wÁɦ¨ÁZ²Ä¤C¡B¤K¦W
¦A¦¸³Â·Ð¡A·PÁ¡I
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_ 5# ymes

¶i¤J¨MÁɪº¿ï¤â¦¨ÁZ¡A­n«öÂŦâ°Ï¶ô±Æ¦W°µ±Æ§Ç¡A
¹ï¤£°_³y¦¨§Aªº§xÂZ¤w¦³§ó·s¡A¥i§_½Ð¦A½T»{¬O§_¦³¨ä¥Lªº°ÝÃD¶Ü?
¤½¦¡Åܱo«Üªø¡A´Á«Ý¤j®v¦³§ó¦nªº¸Ñªk

¹wÁɦ¨ÁZÂàÅܦ¨¨MÁɹD¦¸ÀÉ®×2.zip (20.12 KB)

§ó·s2

TOP

´N¬O³o­Ó¡I´N¬O³o­Ó¡I
ÁöµM¤½¦¡«Üªø¡A¤]ÁÙ¤£¤ÓÀ´¤½¦¡¡A
¦ý«o¹ê¸Ñ¨M¦b¤Uªº§x´b¡A·PÁ¡I
§Æ±æ¤j¤j¯à¤@¤Á¶¶¤ß¡A¸U¨Æ¦p·N
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_ 7# ymes

¤½¦¡ÁYµu¦p¤U¨ä¥L¤£ÅÜ
¥i¥H½ÐÀ°¦£¦A´ú¸Õ¬Ý¬Ý¬O§_¦³¥ô¦ó°ÝÃD¶Ü?
B4:C11 ªº°}¦C¤½¦¡§ï¬°¦p¤U¡A©¹¥k©¹¤U©Ô
B4=INDEX(¤k60M¹wÁɪí!$C:$D,SMALL(IF((¤k60M¹wÁɪí!$H$3:$H$38=$H4),ROW(¤k60M¹wÁɪí!$H$3:$H$38),""),COUNTIF($H$4:$H4,$H4)),COLUMN(A$1))

TOP

°J¤ß·PÁ samwang ¤j¤jªºÀ°¦£¡A¤SÀ°¤p§Ì²¤Æ¤F¡A¸Õ¹L¨S¿ù
¥Î­×§ï«áªºª©¥»§ó®e©ö­×§ï¡A¹ï¦h¶µÀË¿ýªí»s§@§ó«K§Q¤F
(ÁöµMÁÙ¬O¤£¤ÓÀ´¡A¦ý¤é«á©w·|¦n¦n·Q·Q¡I)
¦A¦¸·PÁ¡I
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_ 8# samwang

¤j¤j±z¦n¡G
§Ú­Ì¾Ç®Õ¹B°Ê·|¹wÁɤw¦p¤õ¦p²þ¶i¦æ¤¤¡A
¦ý§Úµo²{¹³ªþ¥ó¤¤¤ñÁÉ¡A§Ú¤£·|­×§ï¤j¤jªº¨ç¼Æ­C¡K¡K
¥i¥H³Â·Ð¤j¤j¦Aµ¹¤©¨ó§U¶Ü¡HÁÂÁÂ

³o¦¸ªº¤ñÁÉ¥i¥Hµ¹¤©¤GºØ°µªk¶Ü¡H
¤@ºØ¬O¨C²Õ¨ú«e¤G¦W¡A¦A¾ÜÀu¤T¦W
¥t¤@ºØ¬Oª½±µ¨ú³Ì¦nªº«e¤C¦W°µ¬°¶i¤J¨MÁɪº¯Z¯Å
³Â·Ð¤À§O±N°µªk¶ñ¤J¤G­Ó¤u§@ªí¶À¦â°Ï¶ô¤¤¡A¦A¦¸³Â·Ð±z¡A·PÁ¡I

¨MÁÉ.rar (43.16 KB)

~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD