10楼 duy3 | 发表于2018-07-18 15:56:02
=IF($Z3=3,CONCATENATE(SUBSTITUTE(MMULT(IF(ISNUMBER(FIND({"1","3","5","7","9"},AA3)),{1,3,5,7,9},),10^{4;3;2;1;0}),0,),),IF($Z3<=2,CONCATENATE(,SUBSTITUTE(MMULT(IF(ISNUMBER(FIND({"1","3","5","7","9"},AB3)),{1,3,5,7,9},),10^{4;3;2;1;0}),0,),),""))
=IF($Z3=3,CONCATENATE(IF(ISERR(FIND("0",AA3)),"",0)&SUBSTITUTE(MMULT(IF(ISNUMBER(FIND({"2","4","6","8"},AA3)),{2,4,6,8},),10^{3;2;1;0}),0,),),IF($Z3<=2,CONCATENATE(,IF(ISERR(FIND("0",AB3)),"",0)&SUBSTITUTE(MMULT(IF(ISNUMBER(FIND({"2","4","6","8"},AB3)),{2,4,6,8},),10^{3;2;1;0}),0,),"")))
=CONCATENATE(LOOKUP(AU3,{"024","026","028","046","048","068","246","248","268","468";"13","15","17","19","35","37","39","57","59","79"}),"",LOOKUP(AT3,{"135","137","139","157","159","179","357","359","379","579";"20","40","60","80","24","26","28","46","48","68"}),)