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.
|