|
发表于 2016-8-23 21:39
|
显示全部楼层
本楼为最佳答案
本帖最后由 Excel学徒123 于 2016-8-24 09:39 编辑
见下代码,具体见附件
- Option Explicit
- Sub test()
- Dim arrSrc, arrRst()
- Dim irow%, irow_1%, icol%, icnt%, icol_1%
- arrSrc = Range("a2").CurrentRegion.Value
- For irow = 3 To UBound(arrSrc)
- If arrSrc(irow, 4) = 2221 And _
- Month(arrSrc(irow, 1)) = 6 _
- And Year(arrSrc(irow, 1)) = 2016 Then
- For irow_1 = 3 To UBound(arrSrc)
- If arrSrc(irow, 1) = arrSrc(irow_1, 1) And _
- arrSrc(irow, 2) = arrSrc(irow_1, 2) And _
- arrSrc(irow, 3) = arrSrc(irow_1, 3) Then
- icnt = icnt + 1
- ReDim Preserve arrRst(1 To 5, 1 To icnt)
- For icol_1 = 1 To 5
- arrRst(icol_1, icnt) = arrSrc(irow_1, icol_1)
- Next
- End If
- Next
- End If
- Next
- Range("i13").Resize(UBound(arrRst, 2), 5) = Application.Transpose(arrRst)
- End Sub
复制代码 |
|