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

½Ð±Ð¿z¿ï¦W¦¸

½Ð±Ð¿z¿ï¦W¦¸

½Ð±Ð¿z¿ï¦W¦¸
Thank!

javascript:;

XX3.jpg (36.51 KB)

XX3.jpg

¦^´_ 1# alvinbluetw

F2=INDEX($B$2:$B$13,MATCH(SMALL($C$2:$C$13-ROW($C$2:$C$13)/100,ROW()-1),$C$2:$C$13-ROW($C$2:$C$13)/100,0)) °}¦C¤½¦¡
G2=VLOOKUP(F2,IF({0,1},$C$2:$C$13,$B$2:$B$13),2,0)

¤Þ¥Î¦ÛHsieh

TOP

¦^´_ 1# alvinbluetw


    F2=INDEX(B:B,RIGHT(SMALL($C$2:$C$13*1000+ROW($C$2:$C$13),ROW(1:1)),3))
             °}¦C¤½¦¡
   G2=SMALL($C$2:$C$13,ROW(1:1))

           °Ñ¦Ò¥Î!

TOP

Thank! ¤G¦ì«e½ú.

G2=VLOOKUP(F2,IF({0,1},$C$2:$C$13,$B$2:$B$13),2,0)
¦b¸ó¤u§@ªí®É,·|¦³¬Y¨Ç­pºâ¤p©ó0.1²£¥Í#N/A.

¨ä¹ê§Ú¥u­n¹LÂo«e3¦W,¨ä¥L¤£­n
§Ú¥Ø«eÁÙ¦A§V¤O¤¤!

Thank! ¦U¦ì

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD