ä½ çå
¬å¼è®¾ç½®æé®é¢ï¼ä½ 设置çå
¬å¼è¡¨è¿°çé»è¾æ¯ï¼Eåçå个æ°æ®å¨Fåä¸çæåï¼Eåçæ°å¨Fåä¸æ²¡æçï¼ç»æå½ç¶æ¾ç¤º#N/Aï¼æ¯å¦E3çæ°åæ¯2ï¼ä½Få没æè¿ä¸ªæ°åï¼æ以G2æ¾ç¤º#N/Aï¼ãåè
ï¼å
¬å¼æåä¸ä¸ªåæ°ä½ å¡«äº1ï¼ä»£è¡¨ä»å°å°å¤§æåºï¼æ¯å¦E2çæ°åæ¯1ï¼å¨Fåæ¯æå°çï¼æ以G2æ¾ç¤º1ï¼ãæä¼°è®¡ä½ æ³è¦çæ¯Fåçå项æ°æ®å¨Fåä¸çæåï¼å
¬å¼åºè¯¥è¿æ ·è®¾ç½®ï¼ä»å¤§å°å°æåºï¼=RANK(F2,F$2:F$13,0)æè
=RANK(F2,F$2:F$13) ä»å°å°å¤§æåºï¼=RANK(F2,F$2:F$13,1)
追é®
æçå
¬å¼æ¯è¿æ ·çï¼åºè¯¥æ²¡éï¼ä»Excelhomeç½ç«ä¸æ¥çå¯è½æ¯æµ®ç¹è¿ç®åå ï¼æ¹ä¸ºæç
§æ¾ç¤ºç²¾åº¦è¿ç®å°±è¡äºã