|
- Public Function 求最近()
- Dim c, d As Date
- Dim e, m, n, z As Integer
- Dim f As String
- m = 2
- z = 0
- Do Until Sheet1.Cells(m, 6).Value = ""
- n = 2
- Do Until Sheet1.Cells(n, 3).Value = ""
- If Sheet1.Cells(n, 2).Value = Sheet1.Cells(m, 5).Value Then
- z = z + 1
- c = FormatDateTime(Sheet1.Cells(n, 3).Value)
- d = FormatDateTime(Sheet1.Cells(m, 6).Value)
- If z = 1 Then
- e = Abs(DateDiff("s", c, d))
- f = Sheet1.Cells(n, 3).Value
- Else
- If Abs(DateDiff("s", c, d)) < e Then
- e = Abs(DateDiff("s", c, d))
- f = Sheet1.Cells(n, 3).Value
- End If
- End If
- End If
- n = n + 1
- Loop
- z = 0
- Sheet1.Cells(m, 7).Value = f
- m = m + 1
- f = ""
- Loop
- End Function
复制代码 |
|