if(count(greparray(F2, len(item) = 0)) = 0, C2, "")
做辅助列,到时候隐藏辅助列
WorkBook569.rar
效果
if(COUNT(o2:o4)=0,"",TODATE(MAX(GREPARRAY(o2:o4,DATETONUMBER(item)))))