Unique Records in Excel

Remove Dupes in a column: Data Menu>Filter>Advanced Filter. Check Copy to another location (select a Copy To range). Unique records only.

Thanks,
Sanjay Bakshi
mesanjaybakshi@gmail.com