Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete records with unique value
i have an xls which has 20000 records in it, it has peoples names in the
first collumn with dob names and addresses in, i want to delete people who only occur once or are unique however as the other fields for the same person are different when i do an auto filter selecting unique records, it displays every record as being unique as there are different values in each field. eg bloggs joe 23/01/20 21 25 12 42 25 bloggs joe 23/01/20 21 20 11 42 85 smith sarah 01/05/06 20 12 51 28 42 smith julie 10/10/80 10 25 32 14 21 smith julie 10/10/80 15 24 24 28 95 from the table i want to delete sarah smith as she only occurs once but doing a advanced filter wouldnt single that record out as the other values are unique any help would be greatly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete records with unique value
Put a column to the left of the names and create a formula: =if(a2=a1,1,"")
This way unique records are highlighted (as well as the first instance of new names). Delete those rows which are truly unique records. -- Brevity is the soul of wit. "Jenna" wrote: i have an xls which has 20000 records in it, it has peoples names in the first collumn with dob names and addresses in, i want to delete people who only occur once or are unique however as the other fields for the same person are different when i do an auto filter selecting unique records, it displays every record as being unique as there are different values in each field. eg bloggs joe 23/01/20 21 25 12 42 25 bloggs joe 23/01/20 21 20 11 42 85 smith sarah 01/05/06 20 12 51 28 42 smith julie 10/10/80 10 25 32 14 21 smith julie 10/10/80 15 24 24 28 95 from the table i want to delete sarah smith as she only occurs once but doing a advanced filter wouldnt single that record out as the other values are unique any help would be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete used records from drop down list? | Excel Worksheet Functions | |||
how to delete duplicate records in a row | Setting up and Configuration of Excel | |||
how to get the number of unique records in a list | Excel Worksheet Functions | |||
Unique records | Excel Discussion (Misc queries) | |||
Deleting specific records | Excel Discussion (Misc queries) |