空一格 不同字母 (12085)

C2=IF((OFFSET(B$1,ROW(A1)-COUNTIF(C$1:C1,""),)=C1)+(ROW(A1)=1)+(C1=""),OFFSET(B$1,ROW(A1)-COUNTIF(C$1:C1,""),)&"","")



留言