Prev: Printing Forms
Next: Text to Number format
From: C. Brown on 2 Apr 2010 08:20
I have a list of 3500 names & addresses in an Excel workbook on one sheet and
some are duplicates. How do I eliminate duplicates?
From: Gary''s Student on 2 Apr 2010 08:31
see:

http://www.cpearson.com/excel/Duplicates.aspx


--
Gary''s Student - gsnu201001


"C. Brown" wrote:

> I have a list of 3500 names & addresses in an Excel workbook on one sheet and
> some are duplicates. How do I eliminate duplicates?
From: David Billigmeier on 2 Apr 2010 16:35
You can bring it into a pivot table, then drag the names and addresses on to
the Row Labels. The pivot table will automatically only display the unique
values

--
Regards,
Dave


"C. Brown" wrote:

> I have a list of 3500 names & addresses in an Excel workbook on one sheet and
> some are duplicates. How do I eliminate duplicates?
From: Ashish Mathur on 4 Apr 2010 22:54
Hi,

You could also use Advanced Filters. In the advanced filters dialog box,
there is a check box for unique records only. Also, when selecting the list
range and criteria range, please select the header row

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"C. Brown" <CBrown(a)discussions.microsoft.com> wrote in message
news:B35B20F4-0ED5-4FAE-884E-DE3F0CB365E6(a)microsoft.com...
> I have a list of 3500 names & addresses in an Excel workbook on one sheet
> and
> some are duplicates. How do I eliminate duplicates?

 | 
Pages: 1
Prev: Printing Forms
Next: Text to Number format