9.8 Deduplication of row-based data - by key column

 

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(Name).(~(1))",A1:D7)

imagepng