|
大于指导日期的配种日期的次数:
- Sub tt()
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- brr = Sheets("配种记录").[a1].CurrentRegion
- For i = 3 To UBound(brr)
- d(brr(i, 1)) = d(brr(i, 1)) & "," & brr(i, 2)
- Next
-
- brr = Sheets("产犊记录").[a1].CurrentRegion
- For i = UBound(brr) To 3 Step -1
- d1(brr(i, 1)) = d1(brr(i, 1)) & "," & brr(i, 3)
- Next
-
- arr = Range("a7:h18")
- For i = 2 To UBound(arr)
- x = arr(i, 2)
- If d.exists(x) Then '配种:大于指定日期的最小日期
- xrr = Split(d(x), ",")
- For k = 1 To UBound(xrr)
- If CDate(xrr(k)) > CDate(arr(i, 6)) Then
- arr(i, 5) = xrr(k)
- s = s + UBound(xrr) - k + 1 '大于指定日期的配种日期的次数
- Exit For
- End If
- Next
- End If
-
-
- If d1.exists(x) Then '产犊:倒数第二
- xrr = Split(d1(x), ",")
- If UBound(xrr) >= 2 Then arr(i, 8) = xrr(2)
- End If
- Next
- [e7].Resize(UBound(arr)) = Application.Index(arr, , 5)
- [h7].Resize(UBound(arr)) = Application.Index(arr, , 8)
- MsgBox "大于指定日期的配种日期的次数为:" & s & "次"
- End Sub
复制代码 |
评分
-
查看全部评分
|