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?

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 DataFilterAdvanced FilterCopy 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
---------------
Jacob Skaria


"Miramar" wrote:

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?

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?