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

[µo°Ý] (¤w¸Ñ¨M)¤½¦¡ªº½d³ò¦Û°Ê§ó·s

[µo°Ý] (¤w¸Ñ¨M)¤½¦¡ªº½d³ò¦Û°Ê§ó·s

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:06 ½s¿è

"=IF(ISERROR(RANK(RC[-2],R6C2:R500C2,0)),""«D20"",IF(RANK(RC[-2],R6C2:R500C2,0)>20,""«D20"",RANK(RC[-2],R6C2:R500C2,0)))"
¤½¦¡¸Ì­±R500C2«ç»ò§ï¦Û°Ê§P§O°Ï°ì
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

«Ø¥ßÅܼÆn
n = [b65536].End(3).Row
µM«á¤½¦¡´N¥i¥H³o¼Ë´À¥NR6C2:R500C2¡G"=****(R6C2:R" & n & "C2)****"

TOP

§Ú¤§«e¦³¥Î³o¼Ëªº¤è¦¡¸Õ
µ²ªGµ²ªG¸ò§Ú­nªº¤£¤@¼Ë
¦A¹ï·Ó¤j¤jªº¸ê®Æ¬Ý¬Ý¦Û¤v¼gªº¦³¨S¦³°ÝÃD
ÁÂÁ³á!
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

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