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

[µo°Ý] ½Ð°Ý­n¦p¦ó¥Î¤é´Á¥h§ä¥X³Ì¤j­È©M³Ì¤p­È

[µo°Ý] ½Ð°Ý­n¦p¦ó¥Î¤é´Á¥h§ä¥X³Ì¤j­È©M³Ì¤p­È

ÁöµM§Ú·|¥ÎMAX(),MIN()¥h§ä,¦ý¦pªG­n¦h²LÂŦâÀx¦s®æ´N¤£ª¾¹D¸Ó«ç»ò¥Î,¦³­þ¦ìª©¤Íª¾¹D,³o¤½¦¡¸Ó«ç»ò¼g

book1.PNG (82.91 KB)

book1.PNG

Book1.rar (3.17 KB)

L3=MAX(IF(($A$2:$A$94>H3)*($A$2:$A$94<I3)*($B$2:$B$94=J3),$C$2:$C$94))
M3=MIN(...
°}¦C¤½¦¡

TOP

¦^´_ 2# ANGELA
ÁÂÁ§Aªº¦^ÂÐ,¤£¹L¦n¹³¤£¦æ­C!§Ú¼Ð°O²LÂŦâ±oÀx¦s®æ,§Æ±æ¥¦¬O¥i¥HÅܰʪº,¤£ºÞ¬OÅܧó¤é´Áªº°Ï¶¡ or A.B.C¼tor Line123³Ì¤j­È¤Î³Ì¤p­È·|ÅÜ°Ê
³o¥Î¨ç¼Æ¬O¦³°µ¨ìªº¶Ü?§Æ±æ¥i¥H

TOP

¦^´_ 3# jovi0801

L3°}¦C¤½¦¡
=MAX(IF((¤é´Á>=$H3)*(¤é´Á<=$I3)*(¼t§O=$J3),INDIRECT($K3),""))
M3°}¦C¤½¦¡
=MIN(IF((¤é´Á>=$H3)*(¤é´Á<=$I3)*(¼t§O=$J3),INDIRECT($K3),""))
¦p¹Ï«Ø¥ß¦WºÙ
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh
¦^´_ 2# ANGELA
ÁÂÁ¨â¦ìªº«ü±Ð,§Ú¤w¸g¾Ç·|¤F,·PÁ§A­Ì:)

TOP

ÁöµM§Ú·|¥ÎMAX(),MIN()¥h§ä,¦ý¦pªG­n¦h²LÂŦâÀx¦s®æ´N¤£ª¾¹D¸Ó«ç»ò¥Î,¦³­þ¦ìª©¤Íª¾¹D,³o¤½¦¡¸Ó«ç»ò¼g
jovi0801 µoªí©ó 2012-8-13 19:00


½Ð°Ñ¦Ò

Book1.rar (3.65 KB)

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD