Identify duplicate names in a database list.

[EPond2130]

Hi All! I need to omit duplicate names in a database. I see that I could use the unique function but am not sure how to apply it to the list. This is probably Excel for Beginners, but I canʻt figure it out.

[#2]

@EPond2130 

Here are some informations from a secret source. 

[#3]

@EPond2130 

A formula that amused me is

= LET(
    distinct,   UNIQUE(list),
    unique,     UNIQUE(list,,TRUE),
    stacked,    VSTACK(distinct, unique),
    duplicates, UNIQUE(stacked,,TRUE),
    duplicates
  )

The variable 'distinct' holds a single copy of each record whereas 'unique' contains only the non-duplicates.  Stacking them produces a list in which the original unique records now appear twice.

Hence 'duplicates' is a lists of records that were duplicated in the original list.