| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
extracting unique rows
Hi,
I am trying to remove duplicate rows(consisting of 8 columns or horizontal cells). any ideas? thanks dan |
|
#2
|
|||
|
|||
|
DataFilterAdvanced Filter.
Check "unique records" and "copy to another location" For more details and pictures see Debra Dalgleish's site http://www.contextures.on.ca/xladvfi....html#FilterUR Gord Dibben Excel MVP On Tue, 19 Apr 2005 17:00:01 -0700, DANmcc wrote: Hi, I am trying to remove duplicate rows(consisting of 8 columns or horizontal cells). any ideas? thanks dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Linear Mode
