第1个回答 2021-10-09
极速^(徽=BS*JY89*757)行业递二^实历强劲
=INDEX($C1:$AI1,SMALL(IF((COUNTIF($C1:$AI1,$C1:$AI1)=MAX(COUNTIF($C1:$AI1,$C1:$AI1)))*(MATCH($C1:$AI1,$C1:$AI1,)
=SUMPRODUCT((LEFT(A$3:A$26,FIND(".",A$3:A$26)-1)
=TRIM(MID(SUBSTITUTE($A2," ",REPT("
",100)),COLUMN(A:A)*100-99,100))-0=IF(COUNT(G1067:I1067)=0,"",IF(COUNTIF(G1067:I1067,">=18")=3,"",""))2、=IF(COUNT(G1067:I1067)>0,"25X18","")