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

[µo°Ý] EXCEL¨ç¼Æ MIN IF

[µo°Ý] EXCEL¨ç¼Æ MIN IF

§Ú³]¤F¦h±ø¥ó§ì¤£µ¥©ó¹sªº³Ì¤p­È¡A¥H¤U¬O§Ú³]ªº¤½¦¡
MIN(IF((ªí¤@!$A$1:$A$60000>=$E$1)*(ªí¤@!$A$1:$A$60000<=$E$2)*(ªí¤@!$B$1:$B$60000=$A3)*(ªí¤@!$L$1:$L$60000>0),ªí¤@!$L$1:$L$60000))
­Y¬O§ä¤£¨ì¸Ó­È¡A§Ú·Q­n§e²{"µL¸ê®Æ"¤T­Ó¦r¡A­n«ç»ò°µ¤~¦n¡AÁٽаª¤â«e½ú­ÌÀ°¦£m(_  _)m

{=IF(SUM((ªí¤@!$A$1:$A$60000>=$E$1)*(ªí¤@!$A$1:$A$60000<=$E$2)*(ªí¤@!$B$1:$B$60000=$A3)*(ªí¤@!$L$1:$L$60000>0))>0,MIN(IF((ªí¤@!$A$1:$A$60000>=$E$1)*(ªí¤@!$A$1:$A$60000<=$E$2)*(ªí¤@!$B$1:$B$60000=$A3)*(ªí¤@!$L$1:$L$60000>0),ªí¤@!$L$1:$L$60000)),"µL¸ê®Æ")}

TOP

JBY¤j¤j¡A§Ú¸Õ¤F±zªº¤½¦¡¡A¤w¸g¦¨¥\¤F¡A·PÁ¤£ºÉm(_  _)m

TOP

IF¨ç¼Æ«Ü¦n¥Î ~~~
kuoliang

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD