One way is to set up a helper column. Assuming the data begins in cell A1, in
cell B2 enter: =if(a2=a1,"Dupe","") and copy the formula all the way down to
the end of your dataset. Then simply delete everything that's labeled as a
Dupe in Column B (using the autofilter is easy, and the first occurence of
each duplicate won't be labeled as such).

"sabogal" wrote:

I have a worksheet with names and addresses sorted in alpha order and I see a
lot of duplicated data, is there an option to delete duplicated data and only
have one record per name?

Thanks!