=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"))