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

¦P¤À¤£¨Ã¦C±Æ¦W(¤p°ÝÃD)

¦P¤À¤£¨Ã¦C±Æ¦W(¤p°ÝÃD)

Dear ¤j¤j­Ì:
     ¦p¦ó±N¦P¤À¼Æªº¶µ¥Ø¡A¨Ì§Ç¨Ã¦C¦W¦¸©O¡H(¤£­«½Æ±Æ¦W)
     °Ñ¾\ªþÀÉ
     ·P®¦

±Æ¦W¤p°ÝÃD.zip (8.3 KB)

¦pªG¦P¤À¼Æ¶µ¥Ø§A·Q­n¥H¤°»ò¬°¨Ì¾Ú¨Ó¨M©w±Æ¦W©O?¶V¦­¥X²{ªº±Æ¦W¶V°ªÁÙ¬O¨Ì¬ì¨t?
¥ÎRank´N¯à²³æ¦C¥X±Æ¦W¤F¡A¦ý¤£ª¾¹D§A¦P¤À®É¡A¥´ºâ®³¤°»ò§@¬°Àu¥ý±Æ¦Wªº¨Ì¾Ú¡A©Ò¥HÁÙ¬O¥ý°Ý¤@¤UXD
¹Ð¥@¤¤ªº¤@­Ó¤p¤pªº¡A¤p®Ñ¹­

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-12-15 09:06 ½s¿è

¦^´_ 1# jj369963
§Q¥Î»²§UÄæ¸ê®Æ²£¥Í¡u¤£­«½Æªº¦W¦¸¡v¡A½Ð°Ñ¨£ªþ¥ó¡I
µù¡G»²§UÄæ¸ê®Æ¥i¦b­ì¸ê®Æªº¤u§@ªí»s§@¡A©Î©ó¥t¤@¤u§@ªí»s§@¡F«Øij¨Ï¥Î¡u©w¸q¦WºÙ¡v(¦p»²§U)¦b³B²z¤W¥i¸û²M·¡¨Ç¡C

±Æ¦W¤p°ÝÃD_¥[»²§UÄæ.zip (8.38 KB)

TOP

¦^´_ 2# zhicha
Dear¤j¤j:

¦pªG¦P¤À¼Æ¶µ¥Ø§A·Q­n¥H¤°»ò¬°¨Ì¾Ú¨Ó¨M©w±Æ¦W©O?¶V¦­¥X²{ªº±Æ¦W¶V°ªÁÙ¬O¨Ì¬ì¨t?
=>¶V¦­¥X²{ªº±Æ¦W¶V°ª¡A³o¼Ëªº¤è¦¡¡A¥i¥H¦p¦ó¼g§PÂ_©O??

·PÁÂ

TOP

¦^´_ 4# jj369963

F3=INDEX($B:$B,SMALL(IF($C$2:$C$17=F4,ROW($C$2:$C$17),""),COUNTIF($F4:F4,F4)))
°}¦C¤½¦¡©¹¥k©Ô
½Ð°Ý¬O³o¼Ë¤l¶Ü?

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD