Data - Filter - Advanced - Unique records only

[Raymond RUSSELL]

Hello all

I'm doing some spring cleaning on the terminology lists
I use in my work as a translator (German to English).
These lists are in three columns entitled
German - English - Subject.

Some of the lists are quite large (several thousand entries)
and over the years a lot of duplicates have crept in.

I want to find (and delete) only those entries that are identical
throughout, i.e. source term AND target term AND subject area.

I have applied <Data> <Advanced filers> <Unique records only>.
This hides - but does not delete - the offending duplicates;
these are still there - just not displayed.

My question is : How can I delete the rows that have been filtered
out by this method ?
Or is there some other way to achieve the same effect ?

Thanks in advance from Ray

 

[Boon]

The only way I can think of is to sort all of the entries
alphabetically with the sort function and then the duplicates will
look obvious.

There is also an ad on the right for something I have never used
before but seems to be your solution.

http://www.add-ins.com/duplicate_finder.htm

 

[Dave Peterson]

After you've filtered in place (to preserve the other columns??), you could copy
the visible cells to a new location.

Select the range to copy
Edit|Goto special|Visible cells only
Edit|Copy
Edit|Paste

=======
If you only have 3 columns, couldn't you just filter to a new location?

=======
Another alternative is to concatenate those fields into a helper column:

=A2&char(1)&c2&char(1)&x2

Then use the techniques a Chip Pearson's site to process those duplicates.
http://www.cpearson.com/excel/Duplicates.aspx