by ~C4Chaos [1]
*_Question by Miquez_: Delete Unique Records in Excel?*
I find it impossible to do the following in Excel.
I have a list of items as follows:
A
A
B
C
C
D
I would like to leave only those items in the list that are listed
more than once. So the desired end result would be:
A
A
C
C
From this list, I could then easily delete the duplicates, which would
leave:
A
C
Background: I have three lists with email addresses from an email
marketing campaign. List 1 contains addresses that bounced in Month 1,
List 1 in Month 2, and List 3 in Month 3. I merged the three lists,
and I would like a final list that contains addresses that bounced in
at least two of the three months. I will then delete these addresses
from our database.
Thanks very much for any help you can give!
*Best answer:*
_Answer by expletive_xom_
merging them into 1 column made it easy.
asssume you merged your list in column A
then in B1 copypaste this formula
=IF(COUNTIF(A:A,A1)>1, IF(COUNTIF($A:A1,A1)=1,A1,""),"")
then copypaste the formula down the column.
you can autofilter column B or sort by column B and delete out the
ones you want.
that will get the
A
C
feel free to update the question or email me if something isnt
working.
edit-
this might work better in B1
=IF(COUNTIF(A:A,A1)>1,A1,"")
copy down and you will get a list of what to delete.
in other words your result
A
A
C
C
*Know better? Leave your own answer in the comments!*
Links:
------
[1] http://www.flickr.com/photos/37996594423@N01/2788692183
http://toponlinemarketingtool.com/?p=1545
________________________________________________________
You have subscribed to these e-mail notices about new posts to the blog.
If you want to change your settings or unsubscribe, please visit:
?code=334794f6fa43e07eeef3448b10c4bdad&addr=thaihabk05.internetmarketing%40blogger.com&
No comments:
Post a Comment