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

[µo°Ý] ±Æ¦W¦¸¡A¦p¦ó´X­Ó¦P¦W¦¸¤§«áÄ~Äò­ì¦W¦¸¶¶§Ç¡H

[µo°Ý] ±Æ¦W¦¸¡A¦p¦ó´X­Ó¦P¦W¦¸¤§«áÄ~Äò­ì¦W¦¸¶¶§Ç¡H

¦³ÂIÃ㤣¹F·N¡C¤£¦n·N«ä¡C¦p¤U¹Ï I5 ªºÄæ¦ì¬O±µµÛ±Æ¦W¬O2¡A¦Ó¤£¬O3
[attachimg]
(§ä¤£¨ì¤W¶ÇÀɮתº¤èªk¡AµLªk¤W¶Ç ¡A©êºp)

01.jpg (69.86 KB)

01.jpg

¦^´_ 1# kaigan89
¬O­n"¤¤¦¡±Æ¦W"¶Ü ?

J2¶ñ¤J¤½¦¡  
=SUMPRODUCT(($G$2:$G$11>G2)*(1/(COUNTIF($G$2:$G$11,$G$2:$G$11))))+1  
¤U©Ô¶ñº¡

TOP

¦^´_ 2# Airman


    ¤Ó¼F®`¤F¡I¯u´Î¡IÁÂÁ§A¡C
¥tºÃ°Ý¡G¯à¤£¯à²³æªº¥Î rank(  )³o­Ó¨ç¼Æ°µ°ò¦½s¼g¹F¨ì¬Û¦Pªºµ²ªG¡H

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD