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

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

[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

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