方法一:新增一列【时长】,然后把【处理时长】整列的数据,拷贝粘贴过去;
方法二:参考代码
Dim t As Table = Tables("表A")
Dim d As Double
Dim str As String = "-1,"
For Each r As Row In t.rows
If r("第二列") > "" AndAlso Double.TryParse(r("第二列"), d) = False Then
str &= r("_Identify") & ","
End If
Next
t.filter = "_Identify in (" & str.trim(",") & ")"