QQ网名大全

您好,非常感谢昨天的解答,还想再麻烦一下

根据提供的表格,直接修改g5单元格公式:
=if(and(b5>=c5,b5>=e5),if(count($g$4:$g4)*count($h$4:$h4),if(match(9e+307,$g$4:$g4)<match(9e+307,$h$4:$h4),b5,""),b5),"")

h5单元格公式:
=if(and(b5<c5,b5<e5),if(count($g$4:$g4)*count($h$4:$h4),if(match(9e+307,$g$4:$g4)>match(9e+307,$h$4:$h4),b5,""),b5),"")
佚名
2024-05-19 14:32:16
最佳回答
类似问题(10)