Archive of Mr Excel Message Board

The easiest way would be to import the file into Access and doing a simple query, grouping by the field that contains duplicates. A pivot table in Excel can also give you a list of unique entries, but it's harder to extract data from a pivot table, since they're mainly for reports. So, if you have access, import your data, run the query, and then export it back to Excel.

-Ben

what it is, is whole lines repeated, i'll see if i can work it out, never really used access, so any pointer would be nice,

cheers ian

Hi Ian, an easy way to clean out the duplicates is to first sort your data and then perform an advanced filter. To do the advanced filter, select Data|Filter|Advanced Filter - a pop-up box will appear. Select "Copy to a another location", select your list range, select your location to copy the filtered data (in the "Copy to:" box), and check the "Unique Records Only" box.

If you need any further help let me know.

Regards,
Barrie

The freedownload ASAP Utilities might also help if you're on Windows. You can find the URL thru a search with google.

Aladin