esProc Desktopesproc-desktop.hashnode.dev·Nov 20, 2024#100 — Deduplication of Row-Based Data — by Key ColumnProblem description & analysis: There is a data table: Task: Find out the data that are not duplicates and the first duplicate data in the Name column. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).group(Name).(~(1))",A1:D7) The ...10 likesexcelAdd a thoughtful commentNo comments yetBe the first to start the conversation.
