Use Advanced Filter to get rid of duplicates in your spreadsheet

Having duplicate rows or entries in your spreadsheet can drive you up the wall. It could be that you need to clean up sloppy contact info from your address book, or maybe you need to consolidate several tables into one. There are a lot of possible scenarios where the Advanced Filter tool is the solution for getting rid of duplicates in your spreadsheet.

Advanced Filter

Here is a sample problem.

Each column has duplicate entries.

The first column shows row numbers. The second column shows names. The third column shows email addresses. The fourth column contains dates. The fifth column contains text.

  A B C D
1 Name Email Date Issue
2 Walter blysky@gmail.com 10/1/2012 Health Care Reform
3 Tyrion theimp@gmail.com 10/1/2012 Health Care Reform
4 Dan dandority@gmail.com 10/1/2012 Health Care Reform
5 Glenn go-to-town@gmail.com 10/1/2012 Health Care Reform
6 Tyrion theimp@gmail.com 9/24/2012 Foreclosures
7 Glenn go-to-town@gmail.com 9/24/2012 Foreclosures
8 Kalinda investigator@gmail.com 9/24/2012 Foreclosures
9 Walter blysky@gmail.com 9/24/2012 Foreclosures
10 Glenn go-to-town@gmail.com 9/17/2012 Schools
11 Dan dandority@gmail.com 9/17/2012 Schools
12 Tyrion theimp@gmail.com 9/17/2012 Schools
13 Tyrion theimp@gmail.com 9/10/2012 Immigration Reform
14 Tyrion theimp@gmail.com 9/3/2012 Fracking

Continue reading