EXCEL中如何按照abcd bcda cdab dabc abcd 的顺序填充，即堆栈的形式排列，先进先出。
发布网友
发布时间：2022-04-29 05:17
共2个回答
热心网友
时间：2023-10-12 20:51
见截图
A2输入
=MID($A$1,MOD(ROW(A1),4)+1,1)&MID($A$1,MOD(ROW(A2),4)+1,1)&MID($A$1,MOD(ROW(A3),4)+1,1)&MID($A$1,MOD(ROW(A4),4)+1,1)
下拉
不知道是不是你说的意思
追问A2输入
=IF(COLUMN()=7,$A2,B2)
公式右拉再下拉
热心网友
时间：2023-10-12 20:52
=CHOOSE(MOD(ROW(A4),4)+1,"A","B","C","D")&CHOOSE(MOD(ROW(A1),4)+1,"A","B","C","D")&CHOOSE(MOD(ROW(A2),4)+1,"A","B","C","D")&CHOOSE(MOD(ROW(A3),4)+1,"A","B","C","D")
下拉。追问
我是想要这样
=CHAR(64+MOD(COLUMN(E1)+ROW(A1),6)+1)
右拉到F2，再下拉。
热心网友
时间：2023-10-12 20:51
见截图
A2输入
=MID($A$1,MOD(ROW(A1),4)+1,1)&MID($A$1,MOD(ROW(A2),4)+1,1)&MID($A$1,MOD(ROW(A3),4)+1,1)&MID($A$1,MOD(ROW(A4),4)+1,1)
下拉
不知道是不是你说的意思
追问A2输入
=IF(COLUMN()=7,$A2,B2)
公式右拉再下拉
热心网友
时间：2023-10-12 20:52
=CHOOSE(MOD(ROW(A4),4)+1,"A","B","C","D")&CHOOSE(MOD(ROW(A1),4)+1,"A","B","C","D")&CHOOSE(MOD(ROW(A2),4)+1,"A","B","C","D")&CHOOSE(MOD(ROW(A3),4)+1,"A","B","C","D")
下拉。追问
我是想要这样
=CHAR(64+MOD(COLUMN(E1)+ROW(A1),6)+1)
右拉到F2，再下拉。
