复制行标题到SHEET2,在SHEET2的A2输入公式:=IF(ROW(A1)>COUNTIF(SHEET1!$A:$A,"A"),"",INDEX(SHEET1!A:A,SMALL(IF(SHEET1!$A$1:$A$1000="A",ROW(SHEET1!$A$1:$A$1000)),ROW(A1)),))用CTRL+SHIFT+ENTER结束输入公式往右拉至E列,往下拉到足够多的行SHEET3方法相同,把"A"改成"B"就行 公式说明:第一步:SMALL(IF(SHEET1!$A$1:$A$1000="A",ROW(SHEET1!$A$1:$A$1000)),ROW(A1))IF+ROW提取A列中包
|