|
连次数天数也可以一起解决:- Sub test()
- Dim I%, J%, K%, N%, C%, T%
- Range("O3:Q65536").ClearContents
- For I = 3 To Range("M65536").End(3).Row
- Set D = CreateObject("scripting.dictionary")
- C = 0: T = 0
- If Cells(I, "Q").MergeCells Then N = Cells(I, "Q").MergeArea.Count - 1 Else N = 0
- For J = 0 To N
- For K = 4 To 12
- If Trim(Cells(I + J, K)) <> "" Then
- D(Cells(2, K).Value) = ""
- C = C + 1
- T = T + Cells(I + J, K)
- End If
- Next
- Next
- Cells(I, "O") = C
- Cells(I, "P") = T
- Cells(I, "Q") = Join(D.KEYS, "&")
- I = I + N
- Next
- End Sub
复制代码 |
|