| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 38168 | 2003-09-29 10:24:00 | Search-Delete duplicated Excel text entries | Ron_A (1369) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 178988 | 2003-09-29 10:24:00 | Hi Have a list of spammers domains in Excel with several entries duplicated. Is there an easy way to identify the duplications and remove the extra entries without examining EVERY cell? TIA Ron |
Ron_A (1369) | ||
| 178989 | 2003-09-29 10:51:00 | Sort the list Then test for duplicates, using the column beside the sorted list: IF (A1=A2,"x","") Copy this down the column, it assumes that your list starts at A1 Then sort the list again, include the new column, sort on the "x" (descending sort) Delete the rows that have "x" Continue to add entries and repeat above And I hope someone has a simpler method as I have a need from time to time ... |
godfather (25) | ||
| 178990 | 2003-09-29 22:43:00 | Hi Your solution worked fine Thanks Ron |
Ron_A (1369) | ||
| 178991 | 2003-09-30 00:52:00 | Hi as an alternative have a look at Chip Pearsons site where he lists different ways for finding duplicates. See here. (www.cpearson.com) Its a great site and I recommend bookmarking the topic list (www.cpearson.com) :-) |
parry (27) | ||
| 178992 | 2003-09-30 01:23:00 | Thanks parry. Have bookmarked it for future reference. | godfather (25) | ||
| 178993 | 2003-09-30 02:19:00 | Here is one simple way of getting a unique list of records without resorting to formulas or code. First, highlight the cells of interest and then go to Data -> Filter -> Advanced Filter. In the dialogue box that comes up select 'unique records only' and then choose whether you want to copy the unique values to a new column or to hide the duplicate entries within the highlighted cells and select ok. That's it - you now have a unique listing! |
odyssey (4613) | ||
| 1 | |||||