[µo°Ý] ¤@¦ê¼Æ¦r¤¤ ¿ï¨ú¸ê®Æ ½Ð±Ð¦U¦ì

greedner

136
139.5               ®ÇÃä¤@¦ê¼Æ¦r §Ú§Æ±æ§ä¥X >136 ªº³Ì¤p¼Æ¦r ¥H¤Î ²Ä¤G¤p ²Ä¤T¤p
130.5               ½Ð°Ý§Ú¸Ó«ç»ò¼g ·Q«Ü¤[ ÁÂÁÂ
133
132
125.5
127.5
126
126
128.5
126.5
126
135
133
132.5
133
132
130
134
135
140
139
138.5

greedner

¦^´_ 7# owen06


    ·PÁ¨â¦ìªº¦^ÂÐ ÁÂÁÂ

owen06

¦^´_ 4# greedner

=LARGE($A$1:$A$23,COUNTIF($A$1:$A$23,">"&E3))

³o¼Ë

ML089

¦^´_ 1# greedner


    =SMALL(IF(A$1:A$23>136,A$1:A$23),ROW(A1))
°}¦C¤½¦¡ (¥H CTRL+SHIFT+ENTER ¤TÁä»ô«ö¤è¦¡¿é¤J¤½¦¡)
¿é¤J«á¤½¦¡«e«á·|¥[¤W {¤½¦¡}

ML089

¦^´_ 4# greedner


    COUNTIF($A$1:$A$23,">"&E3)

greedner

¦^´_ 3# greedner


    ©êºp ¦pªG >136 Åܦ¨¬Y¤@­Ó ¤ñ¦p >e3³o®æ ¸Ó«ç¼g

greedner

¦^´_ 2# owen06


    ·PÁ §Útry¬Ý¬Ý

owen06

¦^´_ 1# greedner


  ¤j©ó136ªº³Ì¤p­È=LARGE($A$1:$A$23,COUNTIF($A$1:$A$23,">136"))
                       ²Ä¤G¤p=LARGE($A$1:$A$23,COUNTIF($A$1:$A$23,">136")-1)
                       ²Ä¤T¤p=LARGE($A$1:$A$23,COUNTIF($A$1:$A$23,">136")-2)