View Single Post
  #3   Report Post  
Herbert Seidenberg
 
Posts: n/a
Default

Select all names, including headers. Name selection ArrayS.
Select equal size destination area and name it ArrayD.

Data | Filter | Advanced Filter | Copy to another location |
List range: ArrayS | Copy to: ArrayD | Unique records only | OK

Instead of | Copy to another location |, you can | Filter the list,
in-place |,
but this merely hides the duplicate rows.