月份溫度最高 年與溫度 (13434)

F2{=RIGHT(MAX((MONTH(B$2:C$16)=E2)*C$2:C$16*10^6+YEAR(B$2:B$16)),4)*1

G2{=MAX((YEAR(B$2:B$16)=F2)*(MONTH(B$2:B$16)=E2)*C$2:C$16)



留言