ÅܼưÝÃD

jim

¦U¦ì¦n½Ð«ü¾É¤U¦C°ÝÃDÀ³¦p¦óÅã¥Ü
  (D5:D32="M"),¦Ó·Q§â32Åܬ°ÅܼÆ, ¨ä©Ò¦bAB3Àx¦s®æ­È¬O 32
   §Y¬° (D5:"D"& [AB3]="M" )  ??   À³¦p¦ó¼g¤~¯àÅã¥Ü¥X¨Ó ÁÂÁÂ

c_c_lai

¦U¦ì¦n½Ð«ü¾É¤U¦C°ÝÃDÀ³¦p¦óÅã¥Ü
  (D532="M"),¦Ó·Q§â32Åܬ°ÅܼÆ, ¨ä©Ò¦bAB3Àx¦s®æ­È¬O 32
   §Y¬° (D5 ...
jim µoªí©ó 2016-6-2 15:57

§A·Qªí¹Fªº¬O³o­Ó¶Ü¡H
Sub M()
    Range("D5:D"& [AB3])="M"
End Sub

jim

c_c_lai  ¦hÁÂ
¦ý©Ò­n¨D«D¦bvbaµ{¦¡¤º,¦Ó¬O¦b¤@¯ëÀx¦s®æ¤º¤½¦¡

hcm19522

INDIRECT("D5:D"&AB3)="M"
«Ü¦hÃþ¦üÃD
http://blog.xuite.net/hcm19522/twblog

jim

hcm19522
·PÁÂ

jim

¦A½Ð±Ð  AB2=152
if(M5="",AC2,MIN(IF(D5152="M",M5:M152))
if(M5="",AC2,MIN(IF(INDIRECT("D5"&AB2)="M",INDIRECT("M5:M"&AB2))
¬O§_¦p¦¹,ÁÙ¬O¥t¦³¥Lªk , ¤S¦pªG³æ¤@¦bRange(m5:m152)¤S¦p¦ó

hcm19522

¦^´_ 6# jim
=IF(M5="",AC2,MIN(IF(INDIRECT("D5:"&AB2)="M",INDIRECT("M5:M"&AB2))))
ªí±¡¹Ï®×¨ú®ø ,"¸T¥Îªí±¡"¦³¥´¤Ä ,ÂI±¼¦AÂI¦^ ,´N¤£·|¥X²{

jim

¦^´_ 7# hcm19522
¯u¦hÁÂ