Help required with complex Removing of Duplicates
 

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?

Help required with complex Removing of Duplicates
 

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?

Help required with complex Removing of Duplicates
 

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?