EXCEL - How to remove duplicate emails from list 2 that are in list 1???

worm · Sep 12, 2008, 03:56 AM

Hi all, ok I'm a Graphic designer not a technical guy - I'm working on a

iMac G5 in EXCEL - and need help on How to remove duplicate emails from list 2 that are in list 1???

Does anyone have a link or could be so kind as to post me the several steps necessary to accomplish this feat!

Thanks in advance

Worm

NAG · Sep 12, 2008, 09:48 AM

Do you mean Entourage and not Excel? Excel is a spreadsheet app.

Corrado33 · Sep 12, 2008, 11:37 AM

So you want to remove the e-mails from list 2 that are in list 1. Meaning if somebody@somewhere.net is in list 1 you want it removed from list 2. Kind of like you have a list of people that are no longer part of the e-mail mailing list and you want to remove those e-mails from the mailing list.

MCRunning · Sep 12, 2008, 11:54 AM

This should do it:

Combine list 1 and 2
Select the entire column where list 1 and 2 combined
Go to Data > Filter > Advanced Filter
If a message comes up just click "OK"
For Action select "Copy to another location"
Where it says "Copy to" - enter in which column/rows you want to paste it to. Example $C$1
Then check the box that says "unique records only"
Select Ok

MC

Sep 12, 2008, 03:56 AM	#1
worm macrumors newbie Join Date: Sep 2008 Location: UK	EXCEL - How to remove duplicate emails from list 2 that are in list 1??? Hi all, ok I'm a Graphic designer not a technical guy - I'm working on a iMac G5 in EXCEL - and need help on How to remove duplicate emails from list 2 that are in list 1??? Does anyone have a link or could be so kind as to post me the several steps necessary to accomplish this feat! Thanks in advance Worm
	0

Sep 12, 2008, 09:48 AM	#2
NAG macrumors 68030 Join Date: Aug 2003 Location: /usr/local/apps/nag	Do you mean Entourage and not Excel? Excel is a spreadsheet app. __________________ Thirty-one days ago it was earlier.
	0

Sep 12, 2008, 11:54 AM	#4
MCRunning macrumors 6502 Join Date: Sep 2008	This should do it: Combine list 1 and 2 Select the entire column where list 1 and 2 combined Go to Data > Filter > Advanced Filter If a message comes up just click "OK" For Action select "Copy to another location" Where it says "Copy to" - enter in which column/rows you want to paste it to. Example $C$1 Then check the box that says "unique records only" Select Ok MC
	0

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
thread	Thread Starter	Forum	Replies	Last Post
How to supercharge Mini?	ranny2	Mac mini	18	Oct 27, 2011 08:53 PM
How To Remove Server Part Of Lion?	hhaydenn	iMac	2	Aug 18, 2011 05:21 PM
How to remove app icons	Boca	Mac Basics and Help	8	May 21, 2011 07:10 PM
How to create search function on 100+ PDFs that are in a DVD	macaddict23	Web Design and Development	4	Nov 25, 2008 02:30 PM
Leopard Screen Sharing - How to remove a computer from My Computers List	m021478	OS X	9	Sep 9, 2008 11:33 AM

Sep 12, 2008, 11:37 AM	#3
Corrado33 macrumors member Join Date: Sep 2008	So you want to remove the e-mails from list 2 that are in list 1. Meaning if somebody@somewhere.net is in list 1 you want it removed from list 2. Kind of like you have a list of people that are no longer part of the e-mail mailing list and you want to remove those e-mails from the mailing list.
	0


MacRumors Forums > Apple Systems and Services > Mac Basics and Help