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

§ä¦P¤@¦C¤¤¤£¬°0ªº³Ì¤p­È

§ä¦P¤@¦C¤¤¤£¬°0ªº³Ì¤p­È

½Ð°Ý¥ý¶i¡A¦pÃD¡A¦P¦C¤¤<>0ªº³Ì¤p­È¡A¦³¤°»ò¨ç¼Æ¥i¹F¦¨¶Ü?
  ·j¤F¤@¤U¡AÁÙ¨S§ä¨ìÃþ¦üªº§@ªk~

  ÁÂÁ¤j®a~

¨Ò¦p §äA1:K1¤¤¤£µ¥©ó0ªº³Ì¤p­È

=MIN(IF(A1:K1<>0,A1:K1))
¨Ï¥Î°}¦C¿é¤J¤½¦¡( CTRL+SHIFT+ENTER»ô«ö¿é¤J¤½¦¡)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

  ¶â¶â¡A¯uªº¥i¦æ¤F,ÁÂÁ±z~

TOP

½Ð°Ý¥ý¶i¡A¦pÃD¡A¦P¦C¤¤0ªº³Ì¤p­È¡A¦³¤°»ò¨ç¼Æ¥i¹F¦¨¶Ü?......
  


«D¹sªº³Ì¤p­È, ¤@¯ë¤½¦¡´N¦æ¤F¡G

=LARGE(A1:K1,COUNTIF(A1:K1,">0"))

TOP

¦^´_ 4# JBY

  ÁÂÁÂJBY~¤S¦h¾Ç¤@­Ó¨ç¼Æ¤F.

TOP

¦^´_ 4# JBY
¥¿¦b¬°³o­Ó°ÝÃD·Ð´o,¯u¬OÀ°¤F¤j¦£....ÁÂÁÂ

TOP

¦^´_ 6# PJChen


    LARGE() ¹ïÀ³ SMALL()
    MAX()   ¹ïÀ³  MIN()

     °Ñ¦Ò°Õ

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD