...
9.11 Deduplication of row-based data - by key column - keeping order
There is a data table:
Find out the data that are not duplicate and the first duplicate data in the Name column:
=spl("=E(?1).group@u(Name).(~(1))",A1:D7)
