Help required with complex Removing of Duplicates

[Miramar]

Hmm... wondering if anyone can help me with an Excel query.

Basically... I have a database of information prepared in Excel. One of the
column headings is 'Year' (Data currently throughout this column is 2008). I
have another column as Email addresses. I am now incorporating a new database
into this with Year column data now reading as 2009. What I want to do is to
delete any duplicate emails. When I do this, if there is a 2009 duplicate
record, I want this information to be kept and the 2008 row data to be
deleted.

Any ideas?

 

[Jacob Skaria]

Try AutoFilter option..

1. Select the range in Col A and B including the header. You need to have
headers for these columns
2. From menu Data>Filter>Advanced Filter>Copy to another location
3. In copy to I have selected G1 and check 'Unique records only'
4. Click OK will give you the unique list of year and email ID in Col G and H.

If this post helps click Yes

 

[Ashish Mathur]

Hi,

Assume that your data is in range B3:C17 (including the headers). In cell
F4, type =AND(COUNTIF($C$4:$C$17,C4)>1,B4=2008)=FALSE. Now click on any
blank cell (on the same worksheet) and go to Data > Filter > Advanced Filter

Copy to another location. In the list range, select B3:C17. In the

criteria range, select F3:F4. In the copy to box, select any blank cell (on
the same worksheet) and now click on OK.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com