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

±Æ¦W¨D³Ó²v¦Ê¤À¤ñ

±Æ¦W¨D³Ó²v¦Ê¤À¤ñ

¦U¦ì¤j¤j
§Ú¦b»s§@¤@­Ó¦¨ÁZ¤À¼Æ»P³Ó²v¦Ê¤À¤ñ¡A¥Ø«e¹J¨ì´X­Ó°ÝÃD
¥H¤U¥H¤­­Ó¾Ç¥Í¬°¨Ò
1.  ·í¤À¼Æ¬°80,90,95,95,100®É¡A¦³¨â­Ó¾Ç¥Í¦P®É¬°95¤À®É¡A§Ú¥Ø«e¨D±o¸Ó¾Ç¥Íªº³Ó²v¬°60%¡A¦Ó¤£¬O80%¡A§Ú¸Ó«ç»ò­×¥¿¤½¦¡©O??
2.  ·í¤À¼Æ¬°80,90,95,95,95®É¡A¦³¤T¦ì¾Ç¥Í¦P®É¬°95¤À®É¡A©Ò¦³³Ó²v¤]¬O60%¡A¦Ó¤£¬O100%¡A³o§Ú¸Ó«ç»ò³B²z©O??

½Ð¤j¤j­ÌÀ°¦£¤@¤U¡AÁÂÁÂ

table1.rar (7.49 KB)

=(6-COUNTIF(B$2:B$6,">="&B2))*0.2
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

=(COUNTIF(B:B,"<"&B2)+1)/COUNT(B:B)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

=(COUNTIF(B:B,"
ML089 µoªí©ó 2018-12-28 17:10



¦n¹³µ²ªG¤@¼Ë³á¡I

TOP

=1-COUNTIF(B:B,">"&B2)/COUNT(B:B)

TOP

=1-COUNTIF(B:B,">"&B2)/COUNT(B:B)
­ã´£³¡ªL µoªí©ó 2018-12-28 18:04



    ÁÂÁª©¥D¦^´_¡A¥i¥H¥Î¤F!!
¤£¹L¡A§Úµe¹Ï¤§«áµo²{§Ú¥i¯àªí¹F¤]¦³°ÝÃD
5­Ó¤H
²Ä¤@¦W¡G100%
²Ä¤G¦W¡G75%
²Ä¤T¦W¡G50%
²Ä¥|¦W¡G25%
²Ä¤­¦W¡G0%
³o¼Ë¤~¹ï

©Ò¥H¡A§Ú«á¨Ó§ï¦¨=(COUNTA(B:B)-1-RANK.EQ(B2,B:B,0))/(COUNTA(B:B)-2)

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD