Hi
Use the advanced filter under tools. Leave the criteria range blank and
filter unique values.
regards
Paul

Tim Walters wrote:

Filtering a list of email addresses in 1 column is very easy. But how can
the rows in other columns also be eliminated together with the duplicate
addresses?

Perhaps I haven't expressed myself clearly.

Column A Column B
Bristol
Bristol
London

How can I eliminate the entire second row in Excel using a filter?

Thanks in advance to anyone who replies?

Tim