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

"Miramar" wrote in message
...
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?