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

[Mark]

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 address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

 

[Debra Dalgleish]

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