如图,A3公式:
=IFERROR(INDEX({"h","1605","@","halo"},IF(ROW(A1)<=24/2,IF(COLUMN()=4,INDEX($A$1:$D$1,MOD(ROW(A4),4)+1),SMALL(IF($A$1:$D$1<>INDEX($A$1:$D$1,MOD(ROW(A4),4)+1),$A$1:$D$1),MOD(COLUMN(A1)+ROW(A1),3)+1)),IF(ROW(A1)<=24,IF(COLUMN()=4,INDEX($A$1:$D$1,MOD(ROW(A4),4)+1),LARGE(IF($A$1:$D$1<>INDEX($A$1:$D$1,MOD(ROW(A4),4)+1),$A$1:$D$1),MOD(COLUMN(A1)+ROW(A1),3)+1)),""))),"")
ctrl+shift+回车,右拉后下拉
追问不是,其实这是密码的一部分,我忘记顺序了
麻烦把它们排列一下