excel - 如何删除 access 或 excel 中的重复和原始条目(多列)

Question

有没有办法删除所有重复的行和excel或access中的原始条目？
我需要删除匹配 3 列的整行。这是一个视觉效果(底部表格是表格应该变成的样子；在这种情况下，具有相同零件号、制造商和制造号的重复件 + 原件被删除):

Answer 1

这在 Access 中似乎对我有用:

DELETE FROM parts
WHERE EXISTS
(
    SELECT p2.[PART NUMBER], p2.[MANUFACTURER], p2.[MANUFACTURER NUMBER]
    FROM parts p2
    WHERE parts.[PART NUMBER] = p2.[PART NUMBER] 
        AND parts.[MANUFACTURER] = p2.[MANUFACTURER] 
        AND parts.[MANUFACTURER NUMBER] = p2.[MANUFACTURER NUMBER]
    GROUP BY p2.[PART NUMBER], p2.[MANUFACTURER], p2.[MANUFACTURER NUMBER]
    HAVING COUNT(*) > 1
)

当我在我的测试数据上运行它时......

PART NUMBER  MANUFACTURER  QUALITY  MANUFACTURER NUMBER
-----------  ------------  -------  -------------------
123          GORD                1  750                
123          OTHER               3  321                
123          OTHER               4  321                

...它删除了两个“其他”行，但单独留下了“GORD”行。