=MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1)&IF(MOD(ROW(A1),2),LEFT(SUBSTITUTE(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1),""))&RIGHT(SUBSTITUTE(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1),"")),RIGHT(SUBSTITUTE(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1),""))&LEFT(SUBSTITUTE(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1),"")))
我都不知道这是多少个字符,要命,
2007版 可用,试试吧,
再问： 出现288等重复时出现错误，只能出现288、288、288、882、882、882本来可以用删除重复解决，但没有出现828组合，有没有办法解决，先谢谢
再答： 重复的的确会出问题，当时考虑过，这个没办法，推翻重来吧，明天给你回复，】 =MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),LOOKUP(MOD(ROW(A1)-1,6)+1,{1,2,3,4,5,6},{1,1,2,2,3,3}),1)&MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),LOOKUP(MOD(ROW(A1)-1,6)+1,{1,2,3,4,5,6},{2,3,1,3,1,2}),1)&MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),LOOKUP(MOD(ROW(A1)-1,6)+1,{1,2,3,4,5,6},{3,2,3,1,2,1}),1)
