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

«ç§PÂ_¬Y¼Æ¦b¤@²Õ¼Æ¦r¤§¶¡?

A1 =10
B1:B100 =RANDBETWEEN(0,99)

=RANK(A1,B1:B100,1)   Åã¥Ü¿ù»~ªí¥ÜB1:B100¸Ì­±¨S¦³A1­È

­Y­n±Æ¦W¥i¥H¥Î COUNTIF
=COUNTIF(B1:B100,"<="&A1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD