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

DataFilterAdvanced 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"
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?