How to delete a master entry and its duplicates

  • Thread starter Thread starter a_evie
  • Start date Start date
A

a_evie

THANX to Peo Sjoblom and Tom Ogilvy.I've finally managed to delete
duplicates...

BUT then I realised..."mmmm I also need to remove the master entry that
has duplicates as well".

E.g. I have one(1) Marilyn on my sheet 1. When I merged sheet 2 and
sheet 3 into the first sheet, I now have 3 more Marilyns.

So how do I delete all the Marilyns (Now 4 of them)?

TQ...
 
TQ

Sorry, as you have started a new thread, I cannot see the original solution.
If you want to delete *all* entries that have duplicates, I would use an
extra column and a COUNTIF() function. Filter (or sort) on this column for
anything greater than 1 and delete them. (This may be best done by pressing
the delete key and then removing the filter and sorting, leaving the blank
rows at the bottom). A formula would look like this. (in B1 for example)

=COUNTIF($A$1:$A$100,A1)
 
Hi Nick,

I have some problems running your mentioned steps....

Basically I have a requirement to delete any name that has duplication.
So all that should be left at the end of teh session should only be
names that never had duplication. The moment an entry has a twin etc,
it must be struck out...i.e. single child only. If you have a twin, you
are out...

I hope I explained it well..

evie
 
Evie

Not sure how the data is laid out, but I guess you are looking in columns,
so if the name you are looking for duplicates is in the range A1:A100 then
in B1 put the formula. copy this down to B100. You will then get a column
with numbers. This is the number of times the name occurs. Sort or filter
this for over 1 and delete them, as they are duplicate entries. You will be
left with *only* entries that had no duplicates
 
Hi Nick,

The sample info looks as follows:
anna 9314566
billy 159745
catherine 5482317
catherine 5482317
deqi 24656622
macy 7789533
macy 7789533
macy 7789533
sally 4746566
shu mah 54564553

My aplogies, I'm terribly new at excel. More of a graphics person all
this while...

Cheers,
Evelyn
 
Evie

Sorry, been away a few days. Am I right in assuming you want to be left
with only

anna 9314566
billy 159745
deqi 24656622
sally 4746566
shu mah 54564553

If so, my suggested route will work. Let me know and I'll send you a
workbook to demonstrate
 
Back
Top