try selecting a cell in the data then datafilteradvance filter and select
unique records only and filter. you can then copy and paste the filtered data.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"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!