是不是曾经买过彩票，又想研究出来所有的号码组合排列，下面把实际分享出来供小伙伴学习。
操作方法
-
01
在单元格A2中输入01/02×03-04+05#06
-
02
A3单元格输入公式一直下拉=IF(A2=””,””,IF(–RIGHT(A2,2)<33,MID(A2,1,12)&TEXT(MID(A2,13,2)+1,”00″)&”#”&TEXT(RIGHT(A2,2)+1,”00″),IF(AND(–MID(A2,1,2)=28,–MID(A2,4,2)=29,–MID(A2,7,2)=30,–MID(A2,10,2)=31,–MID(A2,13,2)=32,–RIGHT(A2,2)=33),””,IF(AND(–MID(A2,1,2)<28,–MID(A2,4,2)=29,–MID(A2,7,2)=30,–MID(A2,10,2)=31,–MID(A2,13,2)=32,–RIGHT(A2,2)=33),TEXT(LEFT(A2,2)+1,”00″)&”/”&TEXT(LEFT(A2,2)+2,”00″)&”×”&TEXT(LEFT(A2,2)+3,”00″)&”-“&TEXT(LEFT(A2,2)+4,”00″)&”+”&TEXT(LEFT(A2,2)+5,”00″)&”#”&TEXT(LEFT(A2,2)+6,”00″),IF(AND(–MID(A2,4,2)<29,–MID(A2,7,2)=30,–MID(A2,10,2)=31,–MID(A2,13,2)=32,–RIGHT(A2,2)=33),TEXT(LEFT(A2,2),”00″)&”/”&TEXT(MID(A2,4,2)+1,”00″)&”×”&TEXT(MID(A2,4,2)+2,”00″)&”-“&TEXT(MID(A2,4,2)+3,”00″)&”+”&TEXT(MID(A2,4,2)+4,”00″)&”#”&TEXT(MID(A2,4,2)+5,”00″),IF(AND(–MID(A2,7,2)<30,–MID(A2,10,2)=31,–MID(A2,13,2)=32,–RIGHT(A2,2)=33),MID(A2,1,6)&TEXT(MID(A2,7,2)+1,”00″)&”-“&TEXT(MID(A2,7,2)+2,”00″)&”+”&TEXT(MID(A2,7,2)+3,”00″)&”#”&TEXT(MID(A2,7,2)+4,”00″),IF(AND(–MID(A2,10,2)<31,–MID(A2,13,2)=32,–RIGHT(A2,2)=33),MID(A2,1,9)&TEXT(MID(A2,10,2)+1,”00″)&”+”&TEXT(MID(A2,10,2)+2,”00″)&”#”&TEXT(MID(A2,10,2)+3,”00″),IF(AND(–MID(A2,13,2)<32,–RIGHT(A2,2)=33),MID(A2,1,12)&TEXT(MID(A2,13,2)+1,”00″)&”#”&TEXT(MID(A2,13,2)+1,”00”)))))))))
-
03
B2单元格输入公式一直右拉在下拉=IF(A2=””,””,IF(–RIGHT(A2,2)=33,””,LEFT(A2,14)&”#”&TEXT(RIGHT(A2,2)+1,”00″)))，就会显示出所有的排列组合
