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

[µo°Ý] §ä²Å¦X±ø¥óªº³Ì¤j­È_¦¸¤j­È

¦^´_ 1# PJChen


±N©p­ì¨Ó¤½¦¡¤¤Max§ï¨Ï¥Îlarge
LARGE(array, k)LARGE ¨ç¼Æ»yªk¨ã¦³¤U¦C¤Þ¼Æ (¤Þ¼Æ¡G±N¸ê°T´£¨Ñµ¹°Ê§@¡B¨Æ¥ó¡B¤èªk¡BÄÝ©Ê¡B¨ç¼Æ©Îµ{§Çªº­È¡C)¡G

Array  ¥²­n¡C³o¬O±z­n§ä¥X²Ä k ­Ó³Ì¤j­È¤§¼Æ­È¸ê®Æªº°}¦C©Î½d³ò¡C
K  ¥²­n¡C³o¬O­n¶Ç¦^¤§¸ê®Æ°}¦C©ÎÀx¦s®æ½d³ò¤¤ªº¦ì¸m (¥Ñ³Ì¤j­Èºâ°_)¡C

D3=IF(LARGE(IF((·R¤ß!$B:$B=$B3),·R¤ß!$D:$D),1)=0,"",LARGE(IF((·R¤ß!$B:$B=$B3),·R¤ß!$D:$D),1))
D4=IF(LARGE(IF((·R¤ß!$B:$B=$B4),·R¤ß!$D:$D),2)=0,"",LARGE(IF((·R¤ß!$B:$B=$B4),·R¤ß!$D:$D),2))
Ctrl+Alt+Enter

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD