Filter Duplicate Data

Ice Cream

New Member
Joined
Feb 15, 2005
Messages
2
I am trying to eliminate duplicates in a database of approx. 30,000 leads. How can I filter the data so only matching names appear? For each lead, I have the propect's name, address, and the date they contacted us.

I greatly appreciate any help that anyone can offer. There might even be free ice cream for the person with a solution (if they live in the US).

Thanks.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Run Advanced Filter on your data from within the destination sheet with the Unique records only option checked.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Ice Cream said:
I've tried, but that doesn't seem to do anything.

Assuming that you want to extract unique records from a data area in a source sheet, make sure that every column of data has a distinctly formatted (bold and in italic, for example) header.

Activate the destination sheet.
Activate Data|Filter|Advanced Filter.
Check the option Copy to another location.
Select the whole data area while in the box for List range.
Leave the box for Criteria range empty.
Select a cell from the destination sheet while in the box for Copy to.
Check the Unique records only option.
Click OK.
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
Hi,

What do you mean by "matching names"? Are you trying to match non-duplicated data with a filtered list?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,924
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top