[已解决]请各位老师帮忙用函数来判断一下，多谢！

流住你

请各位老师帮忙用函数来判断一下，多谢！

最佳答案

月排行榜 / 总排行榜

knifefox

2022-8-16 12:07

=MAX(FREQUENCY(IF(D3:D54<>"错",C3:C54),IF(D3:D54="错",C3:C54)))
=MIN(--TEXT(FREQUENCY(IF(D3:D54<>"错",C3:C54),IF(D3:D54="错",C3:C54)),"0;0;!99"))
=MAX(FREQUENCY(IF(D3:D54="错",C3:C54),IF(D3:D54<>"错",C3:C54)))
=MATCH("错",D3:D54,)-1
=MIN(--TEXT(FREQUENCY(IF(D3:D54="错",C3:C54),IF(D3:D54<>"错",C3:C54)),"0;0;!99"))

跳转到最佳答案楼层

knifefox

=MAX(FREQUENCY(IF(D3:D54<>"错",C3:C54),IF(D3:D54="错",C3:C54)))
=MIN(--TEXT(FREQUENCY(IF(D3:D54<>"错",C3:C54),IF(D3:D54="错",C3:C54)),"0;0;!99"))
=MAX(FREQUENCY(IF(D3:D54="错",C3:C54),IF(D3:D54<>"错",C3:C54)))
=MATCH("错",D3:D54,)-1
=MIN(--TEXT(FREQUENCY(IF(D3:D54="错",C3:C54),IF(D3:D54<>"错",C3:C54)),"0;0;!99"))