ªð¦^¦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®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD