假设你的表头都在第1行,而“序号”、“时间”、“短信内容”、“备注”分别在A1、B1、C1、D1列,请在sheet2的A2输入公式:=IF(COUNTIF(Sheet1!D:D,"温馨提醒")<ROW(A1),"",ROW(A1))B2输入公式:=IF(A2="","",INDIRECT("sheet1!B"&SMALL(IF(Sheet1!$D$2:$D$100="温馨提醒",ROW(Sheet1!$D$2:$D$100)),ROW(A1))))C2输入公式:=IF(A2="","",INDIRECT("sheet1!C"&SMALL(IF(Sheet1!$D$2:$D$100="温馨提醒",ROW(Sheet1!$D$2:$D$
|