ªð¦^¦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 : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD