|
发表于 2011-12-8 19:04
|
显示全部楼层
本楼为最佳答案
- Sub JustTest()
- Dim D As New Dictionary, Ar1, Ar2, Ar3, Mr&, i&, ArrR(), K&
- With Sheets(1)
- Mr = .Cells(.Rows.Count, "r").End(3).Row
- Ar1 = .Range("r2:r" & Mr).Value
- Ar2 = .Range("z2:z" & Mr).Value
- Ar3 = .Range("aj2:aj" & Mr).Value
- End With
- For i = 1 To UBound(Ar1)
- If Not D.Exists(Ar3(i, 1)) Then
- K = K + 1: D.Add Ar3(i, 1), K
- ReDim Preserve ArrR(1 To 4, 1 To K)
- ArrR(1, K) = Ar3(i, 1)
- End If
- ArrR(2, D(Ar3(i, 1))) = ArrR(2, D(Ar3(i, 1))) + 1
- If Ar2(i, 1) - Ar1(i, 1) > 1 Then
- ArrR(4, D(Ar3(i, 1))) = ArrR(4, D(Ar3(i, 1))) + 1
- Else
- ArrR(3, D(Ar3(i, 1))) = ArrR(3, D(Ar3(i, 1))) + 1
- End If
- Next i
- Range("a4:e" & Rows.Count).Clear
- If K > 0 Then
- Range("a5").Resize(K, 4) = Application.Transpose(ArrR)
- [a4] = "合计": [b4:d4].Formula = "=sum(r[1]c:r[" & K & "]c)"
- [e4] = [c4] / [b4]
- Range("e5").Resize(K, 1).Formula = "=rc[-2]/rc[-3]"
- Range("e:e").NumberFormatLocal = "0.00%"
- Range("a4").Resize(K + 1, 5).Borders.LineStyle = 1
- End If
- End Sub
复制代码
有些报告日期比诊断日期还早。。。。?附件中的数据没有超过24小时的,是不是举例有误,还是说明有误。
怎样统计各单位报告卡片的及时性.rar
(76.27 KB, 下载次数: 6)
|
|