esProc Desktopesproc-desktop.hashnode.dev·Nov 21, 2024#101 - Deduplication of Row-Based Data - by Whole RowProblem description & analysis: There is a data table: Task: Find out the whole-row data that are not duplicate and the first duplicate whole-row data. Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group(ID,Name,Gender,Birthday...10 likesexcelAdd a thoughtful commentNo comments yetBe the first to start the conversation.
