随便找个格子，填入以下竖拿睁公式，下敏漏拖余岁填充就行了=LEFT(ADDRESS(1,ROW(A1),4),LEN(ADDRESS(1,ROW(A1),4))-1)
=IF(ROW()>=79,"AAA"&CHAR(ROW()-14),IF(ROW()羡敬>=53,"悄悔AA"兄运慎&CHAR(12+ROW()),IF(ROW()>=27,"A"&CHAR(38+ROW()),CHAR(64+ROW()))))
