Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) | |||
Duplicating Cell Information | Excel Worksheet Functions | |||
Database Information | Excel Worksheet Functions | |||
Duplicate records in Excel | Excel Discussion (Misc queries) |