最小值 同月份 (9449)


D2:D21 (有誤 公式 "嫻" 改 9^9)=TEXT(LOOKUP("嫻",B$2:B2),"M")


G2:G4=MIN(IF(D$2:D$21-F2=0,C$2:C$21))


H2:H4{=MIN(IF(TEXT(LOOKUP(ROW($2:$21),ROW($2:$21)/(B$2:B$21>0),B$2:B$21),"M")-F2=0,C$2:C$21))


留言