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

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