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

[µo°Ý] ¨Ì·ÓÄæ¦ì¦U¤é´Á¡A§PÂ_¤£¦P¤é´Á¡A§ì¨ú¤£­«½Æ¤é´Á

[µo°Ý] ¨Ì·ÓÄæ¦ì¦U¤é´Á¡A§PÂ_¤£¦P¤é´Á¡A§ì¨ú¤£­«½Æ¤é´Á

¥»©«³Ì«á¥Ñ jackson7015 ©ó 2012-5-7 16:31 ½s¿è

°ÝÃD¦pªþ¥ó¤é»xªí¤¤¸ê®Æ
½Ð°Ý°²­Y¢ÐÄ榳¦hºØ¤é´Á¡A¦p¦ó¦b¤é»xªí¤¤ªº¢ÑÄæ§ì¨ú¥X¦U¤Ñ¼Æ¡A¥B¤£­«½Æ¤é´Á
§Ú¦³§ä¨ì¬ÛÃö°Q½×¡A¦ý¬O¥Lª©¦n¹³¨S¦³°µ¥Xª©¥Dªº»Ý¨D
¬Û¦P¤é´Á¤U®»³Ì«á¤@µ§¸ê®Æ
¤é´Á¬d¸ß.rar (11.54 KB)

¦^´_ 1# jackson7015


   ¤é»xªí! C6°}¦C¤½¦¡
=IF(ROW(A1)>SUM(1/COUNTIF(ºî¦X¸ê®Æ®w!$B$5:$B$141,ºî¦X¸ê®Æ®w!$B$5:$B$141)),"",INDEX(ºî¦X¸ê®Æ®w!$B:$B,MIN(IF(ISERROR(MATCH(ºî¦X¸ê®Æ®w!$B$5:$B$141,¤é»xªí!$C$5:C5,0)),ROW($5:$141),"")),))
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

·PÁÂHsiehª©¤jªº¦^À³
¤½¦¡¥i¥H¥¿±`¨Ï¥Î¤F
¹ï°}¦C¤½¦¡ªº¼gªkÁÙ¬O¤£¤Ó¤F¸Ñ,ºCºC¬ã¨s¤¤
ÁÂÁÂÀ°¦£!

TOP

¦^´_ 2# Hsieh

¤£¦n·N«ä,·Q¦A½Ð±ÐHsiehª©¥D
¦]¬°§Úªº¸ê®Æ®w¤ºªº¤é´Á¸ê®Æ·|¤£©w´Á§ó·s,©Ò¥H¦bÁä¤J¤½¦¡«á,¦]¬°¤½¦¡ªº¸ê®Æ½d³ò¬O©T©wªº,©Ò¥H·|¦³¿ù»~
½Ð°Ý
¦pªG¤é´Á¼Æ¶q·|¦³¼W´îªº¸Ü,¤½¦¡¸Ó¦p¦ó§ó§ï ?
¤é´Á¬d¸ß-1.rar (11.41 KB)

TOP

¦^´_ 4# jackson7015

©w¸q¦WºÙx=OFFSET(ºî¦X¸ê®Æ®w!$B$5,,,COUNTA(ºî¦X¸ê®Æ®w!$B$5:$B$65536))

C6=IF(ROW(A1)>SUM(1/COUNTIF(x,x)),"",INDEX(ºî¦X¸ê®Æ®w!$B:$B,MIN(IF(ISERROR(MATCH(x,¤é»xªí!$C$5:C5,0)),ROW(x),"")),))
°}¦C¤½¦¡

TOP

¦^´_ 5# register313

·PÁÂregister313ª©¥DªºÀ°¦£
¹ï©w¸q¦WºÙ­ì¥»ÁÙ¨S¦³¸IIJªº³¡¤À,ÁöµM¤£°÷¤F¸Ñ
¤£¹L¬d¸ß¤F¤@¨Ç¬ÛÃö°T®§©w¸q¦WºÙªº°g«ä,¤]¦³¤F¨Ç»{ª¾


¤½¦¡¥i¥H¥¿±`¨Ï¥Î¤F
·PÁ¦U¦ìªºÀ°¦£

TOP

¦^´_ 2# Hsieh


    ½Ð°Ý±z¬O§_·|Excel¥i¥H¼g¤½¦¡«ü©w§ì¬Y¤Ñªº¸ê®Æ©O¡H

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD