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?