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

[µo°Ý] ·í±Æ¦W¤@¼Ë®É,¦p¦ó³z¹Lvlookup«ö§Ç§ì¨ú¬Û¦P±Æ¦W¸ê®Æ

[µo°Ý] ·í±Æ¦W¤@¼Ë®É,¦p¦ó³z¹Lvlookup«ö§Ç§ì¨ú¬Û¦P±Æ¦W¸ê®Æ

±Æ¦W¬Û¦P.jpg
2012-8-1 09:22
±Æ¦W¬Û¦P.rar (2.45 KB)

½Ð±Ð¦U¦ì¤j¤j:
·í¸ê®Æ¦³±Æ¦W,¨ä¤¤¦³¦hµ§±Æ¦W¤@¼Ë®É,¨Ï¥Îvlookup¨ç¼Æ«ö±Æ¦W§ì¨ú®É,¹J¨ì¦hµ§¬Û¦P±Æ¦W®É·|¥X²{¿ù»~°T®§(¦pªþ¹Ï¤ÎªþÀÉ),½Ð°Ý¸Ó¦p¦ó³z¹Lvlookup«ö§Ç§ì¨ú¬Û¦P±Æ¦Wªº©Ò¦³¸ê®Æ?
peter460191

±Æ¦W¥Î¤¤¦¡±Æ¦W§Y¥i¡C
=RANK(C2,$C$2:$C$20,0)+COUNTIF($C$2:C2,C2)-1

TOP

¦^´_ 2# ANGELA


    ÁÂÁÂANGELA ª©¤jªº«ü¾É¡A¦ý¦pªG±Æ¦W¤£¯àÅÜ°Ê®É(¦P¼Æ¶q­n¦P¦W),¨º¤½¦¡­n¦p¦ó¤U?
peter460191

TOP

F2=IF(ISERROR(VLOOKUP(E2,$A:$C,2,0)),INDEX(B:B,SMALL(IF($C$2:$C$20=G1,ROW($C$2:$C$20)),COUNTIF($G$1:$G1,G1)+1)),VLOOKUP(E2,$A:$C,2,0))
G2=IF(ISERROR(VLOOKUP(E2,$A:$C,3,0)),INDEX(C:C,SMALL(IF($C$2:$C$20=G1,ROW($C$2:$C$20)),COUNTIF($G$1:$G1,G1)+1)),VLOOKUP(E2,$A:$C,3,0))
°}¦C¤½¦¡

TOP

¥»©«³Ì«á¥Ñ peter460191 ©ó 2012-8-1 12:31 ½s¿è

¦^´_ 4# ANGELA


·PÁÂANGELAª©¤jªº«ü¾É,¤w¥i¥H¥Î¤F,¦ý¦³³¡¥÷¤½¦¡¤£¤F¸Ñ¥Î³~,¥¿§V¤O¬ã¨s¤¤¡C
¥t¥~¦A½Ð±Ðª©¤j,¦³¤£¥Î°}¦Cªº¸Ñ¨M¤½¦¡¶Ü?
peter460191

TOP

¥Î¤¤¦¡±Æ¦W¸É§UÄæ¬O³Ì²³æªº¤èªk¡A¥i隐ÂþãÄæ¡C
¨ä¥¦¤èªk³£³Â·Ð¡C¤£¥Î°}¦C¤½¦¡­n©w¸q¦WºÙ¡A¤]¬O³Â·Ð¡C

TOP

¦^´_ 6# ANGELA


    ¤F¸Ñ¤F¡A·PÁ±z¤£§[«ü±Ð!
peter460191

TOP

RE: ·í±Æ¦W¤@¼Ë®É,¦p¦ó³z¹Lvlookup«ö§Ç§ì¨ú¬Û¦P±Æ¦W¸ê®Æ

Archive.Zip (4.9 KB) ¦^´_ 7# peter460191
devidlin

TOP

¦^´_ 6# ANGELA


    ¼Æ¶q¬Û¦Pªº±Æ¦W°ÝÃD­n¦p¦ó­×§ïµ{¦¡?  ÁÂÁÂ
devidlin

TOP

bandicam 2014-12-24 17-54-13-716.jpg
2014-12-24 17:55
¦^´_ 4# ANGELA

javascript:;
   

Archive.Zip (4.9 KB)

devidlin

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD