Duplicate information

I am importing information from another program and I end
up with duplicate rows of information in my spreadsheet.
Is there some way to tell excel to eliminate duplicate
rows either in the import process or afterward?

Stephanie

Data>Filter>Advanced Filter.

Check "copy to a new location" and "unique records only"

For more on this see Debra Dalgleish's site.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben Excel MVP

On Thu, 31 Mar 2005 11:52:16 -0800, "Stephanie"
<anonymous@discussions.microsoft.com> wrote:

>I am importing information from another program and I end
>up with duplicate rows of information in my spreadsheet.
>Is there some way to tell excel to eliminate duplicate
>rows either in the import process or afterward?