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

[µo°Ý] ½Ð±Ð LARGE ¨ç¼Æªº°ÝÃD?

[µo°Ý] ½Ð±Ð LARGE ¨ç¼Æªº°ÝÃD?

½Ð±Ð¦U¦ì¦Ñ®v:
°²³] A1~A10 10¦U¼Æ­È¤À§O¦p¤U: 1  3  4  4  5  6  8  6  6 9

LARGE(A1:A10,1) ¥i¶Ç¦^³Ì¤j­È 9

LARGE(A1:A10,3) ¥i¶Ç¦^³Ì¤j­È 6

LARGE(A1:A10,5) ¥i¶Ç¦^³Ì¤j­È 6 , ½Ð±Ð­Y·Q¶Ç¦^ªº­È,§Æ±æ¦©°£­«½Æ½X,¤]´N¬O»¡ LARGE(A1:A10,5) §Æ±æ¯à¶Ç¦^ªº­È ¬°4
¤£ª¾¹D¸Ó¦p¦ó§@©O?
ÁÂÁÂ
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

=LARGE(IF(FREQUENCY(A1:A9,A1:A10),A1:A10),3)

³o¬Oºô¸ô§ä¨ìªºµª®×,¦ý¬O¥L³o¦Uµª®×¬O¥Î©ó©T©wªºA1~A10,¥i¬O¤p§Ì»Ý­n=LARGE(A1:A3000,1)
¦]¬°¸ê®Æ¼Æ·|¤£Â_¼W¥[,©Ò¥H®K¥ý¿é¤JA3000.
¦]¦¹=LARGE(IF(FREQUENCY(A1:A9,A1:A10),A1:A10),3)³o¤½¦¡µLªk¨Ï¥Î.
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

TOP

¥»©«³Ì«á¥Ñ oobird ©ó 2012-7-1 21:23 ½s¿è

©w¸q¦WºÙ¡Ga  ,°Ñ·Ó¨ì¡G=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A),)
µM«áªí¤Wªº¤½¦¡§ï¬°¡G=LARGE(IF(FREQUENCY(a,a),a),3)

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-7-4 20:01 ½s¿è

oobird ¦Ñ®v:
¥Ñ©ó¤£¤Ó²M·¡   ©w¸q¦WºÙ¡Ga  ,°Ñ·Ó¨ì¡G=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A),)
ªº·N«ä..©Ò¥H¦bhttp://gb.twbts.com/index.php?PH ... v10&topic=469.0   §ä¨ì¥H¤Uµª®×
­n«ç¼Ë©w¸q¦WºÙ©O¡H
¥H¤W­±ªþ¹Ï¨Ó·í§@½d¨Ò¡A­n±NSheet2!B2:B4©w¸q¦WºÙ¬°©Ê§O¡A´N¥ý¿ï¨úSheet2!B2:B4¡A¦A°õ¦æ´¡¤J>>¦WºÙ>>©w¸q¡AµM«á¦b²{¦³¦WºÙ¤º¿é¤J©Ê§O¡A¦A«ö·s¼W>>½T©w§Y¥i¡C
¥t¤@ºØ¸û§Ö³tªº¤è¦¡«h¬O¡A¤@¼Ë¥ý¿ï¨úSheet2!B2:B4¡AµM«á´N¦b¦WºÙ¤è¶ô¤º¿é¤J©Ê§O¡A«ö¤U Enter §Y¥i¡C
¦Û¦æ¬ã¨s¬Ý¬Ý!
ÁÂÁ±z!´£¨Ñ¤@­Ó¤è¦V.
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD