Advanced Filtering Problem

[trebor]

I've have a CSV files that I export from R&R (a report writer) int
Excel. The Excel document has a colomn for first name, last name
company, fax phone #, e-mail address. Unfortunately, some of companie
only have 1 email address, yet several contacts. The result is that
have dozens of records with duplicate addresses. What I want to do i
filter the CSV file in such a way, as to remove a record if it alread
has an e-mail address in another record.

I know how to sort out all the unique e-mails, but I still need th
other information (in the rows) for the e-mail blaster we use.

Any ideas

 

[Debra Dalgleish]

To extract all the data for the first instance of each email address:

1. Leave the heading cell in the criteria area blank
2. In the cell below, enter: =COUNTIF($E$2:E2,E2)=1
where the email addresses start in cell E2
3. When you run the Advanced Filter, select the blank cell and the cell
with the formula as the criteria area.