I have a MS Excel file with mutliple email adresses, some are dulplicates, is there an easy way to delete the duplicates in Excel?

I have a MS Excel file with mutliple email adresses, some are dulplicates, is there an easy way to delete the duplicates in Excel?
by

1 Answer

Answer :

Yes. You’ll need to create filters. In one of the tabs (I think tools) select auto filter. Then you can sort by the column with the email addresses. When you have duplicates, you can highlight and delete the rows you don’t need. Practice on a test file first. Hope this helps.
by

Related questions

Is there a free version of MS Office out there?

Description : Is there a free version of MS Office out there?

Last Answer : Nope. But Google Docs is compatible, and free.

How do you generate a new file for each page of a document, spreadsheet, or pdf?

Description : How do you generate a new file for each page of a document, spreadsheet, or pdf?

Last Answer : answer:I would do this with CutePDF Writer, as we've been discussing in another thread recently. Print each separate page of the document to a new .PDF filename, and then you can do what you like ... Mail Merge document, but you've given so few details that I can't really advise that here yet.

Is there a word for a promise so solemn that the only way you would fail to keep it is if death stopped you?

Description : Is there a word for a promise so solemn that the only way you would fail to keep it is if death stopped you?

Last Answer : A vow.

Is there a way, in Word, to make a dash?

Description : Is there a way, in Word, to make a dash?

Last Answer : maybe wiki can answer this strange question

Why do we say some things in a certain order?

Description : Why do we say some things in a certain order?

Last Answer : This brings to mind a funny story I tell on myself. A Trivial Pursuit question was “Who was Sullivan’s partner?” I kept saying to myself, “Sullivan and? Sullivan and?” I could not get the obvious answer.

What is the new word you learnt lately in a comment section or in Fluther? See Detail.

Description : What is the new word you learnt lately in a comment section or in Fluther? See Detail.

Last Answer : I do remember seeing one lately, and like you, I have since forgotten what it was.

Do you ever use the word "albeit"?

Description : Do you ever use the word "albeit"?

Last Answer : Even though it sounds a little archaic, I use it all the time.

What's your least favorite word?

Description : What's your least favorite word?

Last Answer : Today? “Excessories.”

How do you paste the multiple highlighted paragraphs into Word etc. in one shot?

Description : How do you paste the multiple highlighted paragraphs into Word etc. in one shot?

Last Answer : Press Ctrl, choose the paragraphs, and then go copy-paste. I think you can use the Ctrl+V too, but I’m not sure.

What is an equivalent of aim?

Description : What is an equivalent of aim?

Last Answer : Go to ILoveIM.com

How do you remove formatting from PDF files?

Description : How do you remove formatting from PDF files?

Last Answer : It depends what type of PDF it is. If it's a PDF made from scanned images of a book or journal then your stuck with what you've got. The PDF in this case is basically a stack of images. If ... to convert it to another type of document (for example a word file) and then edit it and convert it back.

Is there a word that combines anthromorphification, nostalgia and overidentifying?

Description : Is there a word that combines anthromorphification, nostalgia and overidentifying?

Last Answer : I think you’re just describing a story that succeeded in engaging the emotions of the audience. Why do you think it requires a special label?

What phrase am I looking for?

Description : What phrase am I looking for?

Last Answer : Wind of Change?

Is hate really a strong word?

Description : Is hate really a strong word?

Last Answer : Yes, it is. I try not to use it. I may dislike a person intensely, but not hate. I reserve that emotion for racism or other hateful emotions/ situations.

In Word, when I hit enter it's "returning" two lines instead of one, even though the line spacing is on 1. How do I change that?

Description : In Word, when I hit enter it's "returning" two lines instead of one, even though the line spacing is on 1. How do I change that?

Last Answer : I usually turn all automatic formatting off . I hate it.

How can I modify graphics used in a Microsoft Word 2007 Document Template?

Description : How can I modify graphics used in a Microsoft Word 2007 Document Template?

Last Answer : I just have the Mac version but a right click provides the option.

How to use a photo emailed me in Word doc.

Description : How to use a photo emailed me in Word doc.

Last Answer : answer:Drag the photo to desktop. Click hold + drag it to desktop

What would be the baking time for a mini loaf?

Description : What would be the baking time for a mini loaf?

Last Answer : answer:Depends on the size. But after you put them in the oven you could take a tooth-pick and use it to prick it. When you see it won’t stick then let it a few more minutes. Or just watch on the colour.

What does "lazy buys" mean?

Description : What does "lazy buys" mean?

Last Answer : It refers to a stock which can be assumed to grow due to market and economic conditions. In other words “lazy” investors who do not take time to research would be attracted to what appears to be a solid stock set to increase in value.

Adjective that comes between suspicious & knowing the whole truth?

Description : Adjective that comes between suspicious & knowing the whole truth?

Last Answer : informed

What does Raj say to the rest of the gang?

Description : What does Raj say to the rest of the gang?

Last Answer : Namaste, white people!

What does it mean, to you, for one to be a 'salt of the earth' kind of person?

Description : What does it mean, to you, for one to be a 'salt of the earth' kind of person?

Last Answer : I guess it means that I’ll be illegal in New York state soon…

Why won't Word let me insert a picture?

Description : Why won't Word let me insert a picture?

Last Answer : Because you didn’t take it out for dinner first… Are you using Word 2007?

If a=1, b=2, c=3 and so on, what would be a word that would add to equal 99?

Description : If a=1, b=2, c=3 and so on, what would be a word that would add to equal 99?

Last Answer : 99/26=3.8 26/3.8=6.8 .8*26=21 letter 21 is U U of course oh i don’t think I read that right…lol

How do I properly export an image I created in One Note to Word?

Description : How do I properly export an image I created in One Note to Word?

Last Answer : I have no idea what One Note is.. but can't you export to an image file? most software have the option to export to PDF or image formats that you can later import into Word. If it doesn't you can always copy ... . 4. Go to Edit> Paste the image 5. Crop it and save as JPG file. 6. Import into Word.

Please help me remember the word or name for this experience.

Description : Please help me remember the word or name for this experience.

Last Answer : There’s a word for that?!?

Have you ever wanted to cause the creative demise of the inventor of something?

Description : Have you ever wanted to cause the creative demise of the inventor of something?

Last Answer : If I had the son of a bitch who invented D&D crap, I would put him in a room where ROCKS FALL EVERYONE DIES. Stupid friends ruined me on D&D.

Word 2007 Form Letter?

Description : Word 2007 Form Letter?

Last Answer : That sounds more like a job for Spreadsheet, instead of Word. Spreadsheet has easy links between text fields. It’s like playing battleship. If you want whats in box A2 to be in box G7, you just type it out.

I am going to kill word '08?

Description : I am going to kill word '08?

Last Answer : …and I thought Word ‘07 sucked.

Is it worth to make an ebook of what used to be issued as a PDF/Word document?

Description : Is it worth to make an ebook of what used to be issued as a PDF/Word document?

Last Answer : The Kindle is far from prime-time. For one thing, their price point for books is way off mark for what you get in return. Because of this, and also due to the overall low adoption rate of e-books ... I do not feel now is the best time to milk the maximum potential of profit by re-releasing a work.

Retrieve a Word document.

Description : Retrieve a Word document.

Last Answer : I don't think so. If Word crashes while you are working on something this is sometimes possible but not if you closed it voluntarily. There is a program out there called GoneIn60s from Download.com that will ... minute after doing so. This won't help you this time I'm afraid but maybe in the future.

How can I convert a Word document to a PDF?

Description : How can I convert a Word document to a PDF?

Last Answer : answer:Open the document you want to save as a PDF file. Choose File > Print. Choose Save as PDF from the PDF pop-up menu, and then choose a name and location for the PDF file. ... You can choose two passwords: one for opening the document, and another for printing or copying from the document.

What is a word that describes the sound of an electronic device?

Description : What is a word that describes the sound of an electronic device?

Last Answer : whir whirrrr

Why is Vista ".zip"ing all my Word files?

Description : Why is Vista ".zip"ing all my Word files?

Last Answer : answer:.docx is not a compression format that's the default format for the latest version of Word 2007 (as part of Office 2007). Your friends are likely running older versions of Word, and hence ... the pop-up and in the resulting dialog, select your preference for Save files in this format .

How do I pull a decent copy of my resume off of Monster?

Description : How do I pull a decent copy of my resume off of Monster?

Last Answer : High light it, save it and copy it onto a text edit or word processing program. The one that comes with your standard OS will work. I guess you figured out it won’t copy worth a darn onto Word. This does work I have copied and saved thousands and thousands of resumes this way.

Docx to doc?

Description : Docx to doc?

Last Answer : answer:you don’t have to pay, you can just re-save the file in 2003 format. click save as and then choose “save in word 2003” format in the list of options. here’s a visual

What is a sentence using the word 'diversion'?

Description : What is a sentence using the word 'diversion'?

Last Answer : Ask-public is a great diversion in the sea of business.

Explain The Flow Of A Typical Instruction Word.?

Description : Explain The Flow Of A Typical Instruction Word.?

Last Answer : Answer :The flow of a typical Instruction word is as follows: The content of the program counter of 2 byte is transferred to the address register known as MAR ( memory address register ). This ... bus. Now the data is placed in the instruction register which will eventually decode and execute it.

In a 16-bit microprocessor, a single word is

Description :  In a 16-bit microprocessor, a single word is A) 16 bit data B) 32 bit data C) 8 bit data D) 64 bit data 

Last Answer :  In a 16-bit microprocessor, a single word is 16 bit data

What is the Gray code word for the binary number 101011?

Description : What is the Gray code word for the binary number 101011?  (1) 101011 (2) 110101 (3) 011111 (4) 111110

Last Answer : What is the Gray code word for the binary number 101011?  (1) 101011 (2) 110101 (3) 011111 (4) 111110

What is the meaning of the word hydroelectric power?

Description : What is the meaning of the word hydroelectric power?

Last Answer : Hydro means water, hydroelectric mean electricity generated from water.

How do I delete duplicates on my itunes?

Description : How do I delete duplicates on my itunes?

Last Answer : answer:You will have to - there is no way to delete duplicates, because iTunes wants YOU to determine which copy you want to keep. Are they exact duplicates? Are they all within the same Music ... different dates in the Date Added column, as this may be the only distinguishing field. Good luck!

How do I send an email to numerous people, so that one recipient can't see the other peoples adresses?

Description : How do I send an email to numerous people, so that one recipient can't see the other peoples adresses?

Last Answer : Do a blind copy. Then it just comes up “undisclosed recipients”.

Is there a free EASY solution for removing duplicates in itunes?

Description : Is there a free EASY solution for removing duplicates in itunes?

Last Answer : yeah, use the view menu to show duplicates, and click away, oh, and when you put in new songs, don’t put in the m3u list, cheers

In MS -Excel, option of NEW is available under which of the following menu: a) Insert b) Home c) File d) None of These

Description : In MS -Excel, option of NEW is available under which of the following menu: a) Insert b) Home c) File d) None of These

Last Answer : c) File

.docx is the file extension for: a) MS Power Point b) MS Excel c) MS Word d) None of These

Description : .docx is the file extension for: a) MS Power Point b) MS Excel c) MS Word d) None of These

Last Answer : c) MS Word

discus the main approaches for managing the design of database system that has mutliple user view?

Description : discus the main approaches for managing the design of database system that has mutliple user view?

Last Answer : For a large multiuser database you'll need to make it robust and fast. If it has a high I/O then a good hard drive array or SSD is best.

When working in excel on my mac, I want to chose File, Send To, and have it use my default email app to send the file (entourage). The mail app overides this though. Any ideas?

Description : When working in excel on my mac, I want to chose File, Send To, and have it use my default email app to send the file (entourage). The mail app overides this though. Any ideas?

Last Answer : answer:Did you also click “Set Entourage to be my default email client” the general tab in Entourage preferences? If that doesn’t work, I think you have found a bug, or as Microsoft would say, an “Undocumented Feature”.

Is there an easy way to send a (large) MP3 file to another email account?

Description : Is there an easy way to send a (large) MP3 file to another email account?

Last Answer : Do you use a cloud, if you do you can upload your show or mp's to a folder of the cloud and grant him/her access to the folder of the cloud and email the link to the cloud. You would be ... copy of the Rolling Stone Magazine, I downloaded it for them and then gave them the link for 30 days access.

Trying to find a source for looking-up Adresses that is ACTUALLY free on the internet...

Description : Trying to find a source for looking-up Adresses that is ACTUALLY free on the internet...

Last Answer : The information you are asking for may not be public so you will need to access from a local IRS database, which costs money. Have you attempted the six degrees of separation attempt? Email some ... are friends with them and go from there. Hopefully track them down by using the domino technique.