excel同一列如何按日期提取日期下数据?答:Sub 日期()Dim i, k For k = 8 To 9 X = WorksheetFunction.Match(Cells(1, k), Range("e:e"), 0)Z = WorksheetFunction.Match(Cells(1, k + 1), Range("e:e"), 0)Range(Cells(X + 1, "E"), Cells(Z - 1, "E")).Copy Cells(2, k)Next Range(Cells(Z + 1, "E...
excel获取某一列对应的多列数据答:在F列建立一个辅助列,在F1单元格输入以下公式,然后向下填充公式 =E1&IF(COUNTIF(D2:D$2000,A1)>0,","&VLOOKUP(D1,D2:F$2000,3,0),"")在C1单元格输入以下公式,然后向下填充公式 =VLOOKUP(A1,D:F,3,0)