S2单元格写入公式
=IF(VLOOKUP(T2,H:I,2,)<6,"春",IF(VLOOKUP(T2,H:I,2,)<11,"夏",IF(VLOOKUP(T2,H:I,2,)<16,"秋","冬")))
或
=LOOKUP(VLOOKUP(T2,H:I,2,),{0,"春";6,"夏";11,"秋";16,"冬"})
下拉填充公式
J4
=IF(COUNTIF(OFFSET(A$3,I3-1,1,1,6),I4),"Y","N")
下拉
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024