#103 — Deduplication of Row-Based Data — by Key Column — Keeping the Original Order

Problem description & analysis: There is a data table: Task: Find out the data that are not duplicate and the first duplicate data in the Name column: Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group@u(Name).(~(1))",A1:D7) ...