Filtering problem

  • Thread starter Thread starter Tim Walters
  • Start date Start date
T

Tim Walters

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
(e-mail address removed) Bristol
(e-mail address removed) Bristol
(e-mail address removed) London

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

Thanks in advance to anyone who replies?

Tim
 
Hi
Use the advanced filter under tools. Leave the criteria range blank and
filter unique values.
regards
Paul
 
Thank you for your reply. But suppose the second entry reads the same in
Column A, but different in Column B, yet I still want to eliminate it
because it's duplicate email addresses I want to get rid of.

Any suggestions?

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with filtering 1
Strip out certain rows that have merged cells 2
Programm Auto filter for overdue time 1
Transpose?? 6
VBA code to Fill Down in a filtered list only to visible cells. 1
Filter problem 2
Date criteria for adv. filter in code 3
Highlight or Mark any values in a column that are duplicates insidethe column 1

Back
Top