G
Guest
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
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