$Q$2:$Q$800<=$Z2<=$R$2:$R$800 这个表达有错误
应为：AND($Q$2:$Q$800<=$Z2, $Z2<=$R$2:$R$800)
=(IF(ISERR(FIND($S2,$D$2:$D$800)),0,1)=1)*($T2=$L$2:$L$800)*($Y2<$Q$2:$Q$800)*($Q$2:$Q$800<=$Z2)*($Z2<=$A$2:$A$800)*ROW($A$2:$A$800)，按Shift+Ctrl+Enter结束
这个公式提示有错误。
这个条件不错
not(ISERR(FIND($S2,$D$2:$D$800)))*($T2=$L$2:$L$800)*($Y2<$Q$2:$Q$800)*($Q$2:$Q$800<=$Z2)*($Z2<=$R$2:$R$800)*ROW($A$2:$A$800)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024