Microsoft Excel 2003 - Deleting rows
The Problem :
Suppose I have the following data arranged in rows. 5 2 3 3 3 3 4 2 3 3 3 4 5 6 6 I wish to delete duplicate values (rows) so that the list becomes : 5 2 3 4 2 3 4 5 6 I do not wish to delete for example all the 3's except one but delete all duplicate 3's from each group of 3's leaving a single 3 in each group. Similarly with other groups e.g in this case the number 6. I want to automate this process. Note all the groups contain consecutive duplicates. Can this be done using an excel formula or excel function or vba code ? I welcome any suggestions -- FLYNNE |
Microsoft Excel 2003 - Deleting rows
Data/Filter/Advanced filter
Select Unique Records Only checkbox Click OK, select the resultant cells, Copy/Paste elsewhere for your new unique list. Bob Umlas Excel MVP "FLYNNE" wrote in message ... The Problem : Suppose I have the following data arranged in rows. 5 2 3 3 3 3 4 2 3 3 3 4 5 6 6 I wish to delete duplicate values (rows) so that the list becomes : 5 2 3 4 2 3 4 5 6 I do not wish to delete for example all the 3's except one but delete all duplicate 3's from each group of 3's leaving a single 3 in each group. Similarly with other groups e.g in this case the number 6. I want to automate this process. Note all the groups contain consecutive duplicates. Can this be done using an excel formula or excel function or vba code ? I welcome any suggestions -- FLYNNE |
Microsoft Excel 2003 - Deleting rows
Thanks Bob - your answer is short , neat and does exactly what is required.
Many thanks -- FLYNNE "Bob Umlas" wrote: Data/Filter/Advanced filter Select Unique Records Only checkbox Click OK, select the resultant cells, Copy/Paste elsewhere for your new unique list. Bob Umlas Excel MVP "FLYNNE" wrote in message ... The Problem : Suppose I have the following data arranged in rows. 5 2 3 3 3 3 4 2 3 3 3 4 5 6 6 I wish to delete duplicate values (rows) so that the list becomes : 5 2 3 4 2 3 4 5 6 I do not wish to delete for example all the 3's except one but delete all duplicate 3's from each group of 3's leaving a single 3 in each group. Similarly with other groups e.g in this case the number 6. I want to automate this process. Note all the groups contain consecutive duplicates. Can this be done using an excel formula or excel function or vba code ? I welcome any suggestions -- FLYNNE |
All times are GMT +1. The time now is 08:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com