| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can excel remove the duplicate rows in a spread sheet?
I have a spread sheet which has rows that are direct duplicates of one
another. That is: the key columns of the row are equal. There may be 11 rows where the key columns are equal. Can Excel remove the second and suceeding duplicate rows, leaving only one row? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can excel remove the duplicate rows in a spread sheet?
See Chip Pearson's page on this topic:
http://www.cpearson.com/excel/duplicat.htm -- Regards, Tom Ogilvy "Robert Moritzky" <Robert wrote in message ... I have a spread sheet which has rows that are direct duplicates of one another. That is: the key columns of the row are equal. There may be 11 rows where the key columns are equal. Can Excel remove the second and suceeding duplicate rows, leaving only one row? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can excel remove the duplicate rows in a spread sheet?
Take a look at the advanced filter. Debra Dalgleish has a good page on
http://www.contextures.com/xladvfilter01.html#FilterUR -- HTH RP "Robert Moritzky" <Robert wrote in message ... I have a spread sheet which has rows that are direct duplicates of one another. That is: the key columns of the row are equal. There may be 11 rows where the key columns are equal. Can Excel remove the second and suceeding duplicate rows, leaving only one row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I REMOVE #VALUE FROM MY SPREAD SHEET | New Users to Excel | |||
| remove duplicate rows from specific data in a column; excel 2007 | Excel Worksheet Functions | |||
| Duplicate records on a spread sheet | Excel Worksheet Functions | |||
| How do I remove an unwanted check box from an Excel spread sheet? | Excel Discussion (Misc queries) | |||
| How do i delete duplicate rows in an Excel Spread Sheet | Excel Worksheet Functions | |||
Hybrid Mode
