sheet2的A4单元格输入公式,按SHIFT+CTRL+ENTER,并向右向下填充即可=if(row(a1)>$O$2,"",index(sheet1!A$1:A$1000,if(sheet1!$A$1:$A$1000="A",row($1:$1000),4^8),row(a1)))&"")
