本帖最后由 tgydslr 于 2015-4-19 09:01 编辑
dulian168 发表于 2015-4-18 20:44
那个红蓝绿的 完全不会模仿 因为红蓝绿的分配是没规律的 还得麻烦下老师 还有请老师把单双 ...
红蓝绿D2- =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(SUM(MATCH(MATCH(--MID(A2,{1,2,3},1),{1,5,9,3,4,8,0,2,6,7},),{1,4,7})*{100,10,1}),"0-0-0"),1,"红"),2,"蓝"),3,"绿")
复制代码 单双E2- =SUBSTITUTE(SUBSTITUTE(TEXT(SUM(MOD(MID(A2,{1,2,3},1),2)*{100,10,1}),"0-0-0"),0,"双"),1,"单")
复制代码 D2简化一些- =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(SUM(MATCH(FIND(MID(A2,{1,2,3},1),1593480267),{1,4,7})*{100,10,1}),"0-0-0"),1,"红"),2,"蓝"),3,"绿")
复制代码 |