[开贴]字符争霸第九期：根据要求填充

baksy

公式好長哦^^
=TEXT(MID(REPT(4,$B$2)&REPT(7,$B$3)&REPT(5,$B$4)&REPT(2,$B$5)&REPT(3,$B$6)&REPT(1,$B$7)&REPT(6,$B$8),ROW(A1),1),IF(D$1="","ddd","aaaa"))

liziyuliziyu7

字符超长，不好意思         
普通公式   



d2=IF(MOD(COLUMN(),2),IF(C2="","",TEXT(FIND(RIGHT($D2),"日一二三四五六"),"ddd")),T(LOOKUP(ROW(A1)-1,SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$8),)),{"星期三";"星期六";"星期四";"星期一";"星期二";"星期日";"星期五";0})))

jio1ye

1. =TEXT(IF(ROW()>SUM($B:$B)+1,"",LOOKUP(MOD(ROW()-2,SUM($B:$B)),MMULT(N(COLUMN($A:$G)<ROW($1:$8)),$B$2:$B$8),{4;7;5;2;3;1;6})),IF(COLUMN()=4,"aaaa","ddd"))

复制代码

153字符，抄袭了他人的思路囧。

chensir

如果可以用自定义的话
公式只要用=INDEX({4;7;5;2;3;1;6},SMALL(IF(COLUMN(A:Z)<=$B$2:$B$8,ROW($1:$7)),ROW(A1)),{1,2})即可
不用自定义，字符多了
=IFERROR(INDEX(IF({1,0},TEXT({4;7;5;2;3;1;6},"aaaa"),TEXT({4;7;5;2;3;1;6},"ddd")),SMALL(IF(COLUMN(A:Z)<=$B$2:$B$8,ROW($1:$7)),ROW(A1)),{1,2}),"")

砂海

=INDEX(IF(COLUMN()=4,{"","星期三","星期六","星期四","星期一","星期二","星期日","星期五",""},{"","Wed","Sat","Thu","Mon","Tue","Sun","Fri",""}),--LEFT(SMALL(IF((--ROW($B$2:$B$8)&{1,2,3,4})>(--ROW($B$2:$B$8)&$B$2:$B$8),999,--(ROW($B$2:$B$8)&{1,2,3,4})),ROW(C1))))

没好意思数.

26759761@qq.com

=IFERROR(TEXT(INDEX({41731;41734;41732;41736;41737;41742;41747},SMALL(IF($B$2:$B$8>=COLUMN($A:$G),ROW($B$1:$B$7)),ROW(A1))),IF(COLUMN()=4,"aaaa","ddd")),"")

wlc520113000

120字符
区域数组D2：E2

TEXT(MID(REPT(4,B$2)&REPT(7,B$3)&REPT(5,B$4)&REPT(2,B$5)&REPT(3,B$6)&REPT(1,B$7)&REPT(6,B$8),ROW(A1),1),{"aaaa","ddd"})
115
=IFERROR(TEXT(LOOKUP(ROW()-2,MMULT(N(COLUMN(A:H)<ROW($1:$8)),--(0&B$2:B$9)),{4;7;5;2;3;1;6;-1}),{"aaaa","ddd"}),"")


区域数组112
D2：E29
=TEXT(MID(REPT(4,B2)&REPT(7,B3)&REPT(5,B4)&REPT(2,B5)&REPT(3,B6)&REPT(1,B7)&REPT(6,B8),ROW()-1,1),{"aaaa","ddd"})
区域数组107
=IFERROR(TEXT(LOOKUP(ROW()-2,MMULT(N(COLUMN(A:H)<ROW(1:8)),0+B2:B9),{4;7;5;2;3;1;6;-1}),{"aaaa","ddd"}),"")

chinaman_86

=TEXT(B2,"[$-804]dddd")
=TEXT(B2,"ddd")

tgydslr

1. =IFERROR(INDEX(TEXT({4;7;5;2;3;8;6},IF(MOD(COLUMN(),2),"ddd","aaaa")),8-MATCH(ROW()-1,SUBTOTAL(9,OFFSET($B$2,,,8-ROW($1:$7)))+ROW($1:$7)/10,-1)),"")
   

复制代码

1. =INDEX(TEXT({4;7;5;2;3;8;6},IF(MOD(COLUMN(),2),"ddd","aaaa")),8-MATCH(ROW()-1,SUBTOTAL(9,OFFSET($B$2,,,8-ROW($1:$7)))+ROW($1:$7)/9,-1))

复制代码

笨笨四

————————————截止阀
此后楼层不再评分。