If it is the former, the 2007 version of excelj will delete duplicates, or the formula = if (match (A 1, $ a: $ a,) -row (A 1), "Recurrence", "") can be pulled down. The word "recurring" appears for the second time or more.
If you delete a cell with the same name, suppose there are 100 rows of data (the names should all be followed by "(",but I think there are no brackets after the names of the third and fourth rows ~), and the array formula {= if (match (mid ($ a $1:$ a $100, $ a).
Ask again if you don't understand.