REQ - Help with merge/delete of duplicate/identical cells

's Computer Specifications

Hi all
I have some data (email addresses) that I've imported into Excel and I'm
trying to delete
the duplicate cells.

eg the Sheet looks like the following and I want to get rid of the
duplicates.
Can someone please tell me how to do this

(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)
(E-Mail Removed)

's Computer Specifications

You can use an Advanced Filter to export a unique list of items. There
are instructions in Excel's Help, and here:

http://www.contextures.com/xla*dvfilter01.html

Mark wrote:
> Hi all
> I have some data (email addresses) that I've imported into Excel and I'm
> trying to delete
> the duplicate cells.
>
> eg the Sheet looks like the following and I want to get rid of the
> duplicates.
> Can someone please tell me how to do this

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
delete identical duplicate records	Jules	Microsoft Access Queries	1	15th Nov 2009 08:42 PM
How to delete "non-identical" duplicate records in an Access table	Ernest Monterrosa	Microsoft Access Queries	3	12th Dec 2007 08:44 PM
Select and merge cells with duplicate values	leonidas	Microsoft Excel Programming	0	22nd Aug 2006 06:03 PM
Can't paste as merge cells aren't identical	=?Utf-8?B?TXV0dGxleQ==?=	Microsoft Excel Programming	1	12th Apr 2006 05:13 PM
How do I delete similar (not identical) duplicate records?	=?Utf-8?B?RXJpYw==?=	Microsoft Access Queries	2	2nd Aug 2005 07:21 AM