Help required with complex Removing of Duplicates

  • Thread starter Thread starter Miramar
  • Start date Start date
M

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?
 
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
 
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
Click to expand...
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
 
Back
Top