求助excel统计彩票的问题 比如号码6 1 2 7 3,我要在G2上显示123,R2上...答:G2 =IF(COUNTIF($B2:$F2,LEFT(G$1,1))*COUNTIF($B2:$F2,MID(G$1,2,1))*COUNTIF($B2:$F2,RIGHT(G$1,LEN(G$1)-2)),G$1,"")横拉 下拉 及时采纳,亲~可追问
EXCEL如何实现以下统计答:把A1规范一下,设置值为“0,1,2,3,4,5,6,7,8,9” ,然后C2公式为:=IF(SUM(IF(ISERR(FIND(ROW(A1)-1,$A$1:$A$100)),0,1))-1<COLUMN(A1),"",SMALL(IF(ISERR(FIND(ROW(A1)-1,$A$1:$A$100)),4^8,ROW(A$1:A$100)),COLUMN(B1))-SMALL(IF(ISERR(FIND(ROW(A1)-1...