Get Rid of Duplicate Cell?


W

Wendy

Hi, I hope someone can help. I have all my customers
emails in Excel. Each email is in a cell. I would like
Excel to find the duplicates for me so that I can delete
them and only have one for each customer. Is there a way
to do this? Or is there a way to do it in word if I can
transfer the info into there?

Thanks for any help!
Wendy
 
Ad

Advertisements

V

Vasant Nanavati

If you don't have too many, the easiest way would be to sort them and
visually inspect them to remove the duplicates.
 
G

Guest

Assuming your email addresses are listed down a column (not across a row)..
1) Click a cell in the column you would like to sort by.
2) Click Sort Ascending (A-Z) or Sort Descending (Z-A
 
Ad

Advertisements

P

Patti

I use conditional formatting to highlight the duplicates --

For example, if my data is in column c, I'd enter the
following formula in conditional formatting:

=countif($C:$C, C1)>1

and use a color for the background.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top