Prev: How to remove automatic calculate function?
Next: entering parameter criteria MS Query
From: Jonathan6315 on 29 Apr 2010 07:44
Hi I've merged 2 mailing list files and have noticed there are a few
duplicate records.Is there a way of de-duping in Excel??
From: Eduardo on 29 Apr 2010 07:49
Hi,
Look CPearson web, go to the middle of the page where it says delete
duplicate rows

http://www.cpearson.com/excel/deleting.htm

"Jonathan6315" wrote:

> Hi I've merged 2 mailing list files and have noticed there are a few
> duplicate records.Is there a way of de-duping in Excel??
From: Jacob Skaria on 29 Apr 2010 08:08
Check out this option.

--Select data range and from menu Data>Filter>Advanced Filter>Copy to
another location..
--In 'copy to' select a cell and check 'Unique records only'
--Click OK ..will give you the unique list


--
Jacob (MVP - Excel)


"Jonathan6315" wrote:

> Hi I've merged 2 mailing list files and have noticed there are a few
> duplicate records.Is there a way of de-duping in Excel??
From: Tom Hutchins on 29 Apr 2010 10:45
If you are using Excel 2007 you can use the 'Remove Duplicates' button on the
Data ribbon.

Hope this helps,

Hutch

"Jonathan6315" wrote:

> Hi I've merged 2 mailing list files and have noticed there are a few
> duplicate records.Is there a way of de-duping in Excel??
 | 
Pages: 1
Prev: How to remove automatic calculate function?
Next: entering parameter criteria MS Query