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

¶Ç¦^ROW

¶Ç¦^ROW

¶Ç¦^ROW ==>LARGE($B$20:$B$26,3)
=ROW(LARGE($B$20:$B$26,3)) ¿ù»~??? ( LARGE§ä¥X¨Óªº­È¨S¿ù)

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-5 12:04 ½s¿è

¦^´_ 1# t8899
¥Î°}¦C¤½¦¡
=SMALL(IF($B$20:$B$26=LARGE($B$20:$B$26,3),ROW($B$20:$B$26),""),1)
$B$20:$B$26ªº½d³ò­YÂX¤j¡A«h«Øij¨Ï¥Î©w¸q¦WºÙ³B²z¸û¬°Â²¼ä¡C
½Ð°Ñ¦Ò¡I

TOP

¦^´_  t8899
¥Î°}¦C¤½¦¡
=SMALL(IF($B$20B$26=LARGE($B$20B$26,3),ROW($B$20B$26),""),1)
$B$20: ...
p212 µoªí©ó 2014-7-5 11:58


¥X²{ #VALUE! Book3.rar (1.35 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-5 23:00 ½s¿è

¦^´_ 4# t8899
ª`·N¡I¡u°}¦C¤½¦¡¡v¥²¶·¥H¡uCtrl+Shift+Enter¡v¿é¤J¡A¬G2#§@ªkÀ³¥i¦æ¡A¤£·|¥X²{¡u #VALUE!¡v¿ù»~°T®§¡A½Ð°Ñ¦Ò¡I

TOP

¦^´_  t8899
ª`·N¡I¡u°}¦C¤½¦¡¡v¥²¶·¥H¡uCtrl+Shift+Enter¡v¿é¤J¡A¬G2#§@ªkÀ³¥i¦æ¡A¤£·|¥X²{¡u #VALUE!¡v ...
p212 µoªí©ó 2014-7-5 22:57


=SMALL($B$20:$B$25,ROW(B3))
½Ð°Ý§Ú§â$B$20:$B$25 ¤¤¶¡ §R±¼´N¥X²{  #num! ,¤£ª¾¦p¦ó§ó§ï?

TOP

¦^´_ 1# t8899

§ä¦ì¸m¥i¥H¥ÎMATCH¨Ó³B²z

=MATCH(LARGE(B20:B26,3),B:B,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD