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
A | B | C | D | |
---|---|---|---|---|
1 | Name | 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 |