主题：[求助]多列内容，如何排除重复值？

 汗，哪里重复啊，品名规格不同啊。

Dim idx As String = "-1,"
Dim pdr As DataRow = Nothing
Dim cs As String = "客户,工序"
Dim flag As Boolean
For Each dr As DataRow In DataTables("询价表").Select("客户 is not null and 工序 is not null", cs)
   
    flag = False
    If pdr IsNot Nothing Then
        For Each c As String In cs.split(",")
            If pdr(c) <> dr(c) Then
                flag = True
                Exit For
            End If
        Next
    End If
    If flag Then
        idx &= pdr("_Identify") & ","
    End If
    pdr = dr
Next
If flag = True Then
    idx &= pdr("_Identify") & ","
End If

Tables("询价表").filter = "_Identify in (" & idx.trim(",") & ") and 客户 is not null and 工序 is not null"

试过您提供的新代码，但是，符合条件的订单全部消失了，排除重复值，不是应该留有其中一个样本吗？

12楼测试，没问题。

此主题相关图片如下：2.png


此主题相关图片如下：1.png

如图，第9、10行订单显示的客户“欣凯”，不见了

你15楼的意思，是不是说少了一个？

 

Dim idx As String = "-1,"
Dim pdr As DataRow = Nothing
Dim cs As String = "客户,工序"
Dim flag As Boolean
For Each dr As DataRow In DataTables("询价表").Select("客户 is not null and 工序 is not null", cs)
    flag = False
    If pdr IsNot Nothing Then
        For Each c As String In cs.split(",")
            If pdr(c) <> dr(c) Then
                flag = True
                Exit For
            End If
        Next
    End If
    If flag Then
        idx &= pdr("_Identify") & ","
    End If
    pdr = dr
Next

If pdr IsNot Nothing Then
    idx &= pdr("_Identify") & ","
End If

Tables("询价表").filter = "_Identify in (" & idx.trim(",") & ") and 客户 is not null and 工序 is not null"

成了，谢谢老师！！！