9.11 Deduplication of row-based data - by key column - keeping order

 

There is a data table:

imagepng

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)

imagepng