Hi
use 'Data - Filter - Advanced Filter' and check 'Unique entries'

--
Regards
Frank Kabel
Frankfurt, Germany


Darlene wrote:
My spreadsheet contains some duplicates in a column. I need to
delete these duplicates automatically leaving the column filled with
a list of unique entries and no duplicates. Is there an easy
solution? Thanks