Finding Duplicates in Excel 2007

On the December 27, 2006 episode of Call for Help, I show off some new features in Excel 2007.

A common problem in Excel is how to find the unique values from a range. In the show, you will see three methods that have been around in various versions of Excel:
Advanced Filter
COUNTIF function
Pivot Table

I also show off two new features from Excel 2007 that allow you to either mark duplicates or remove duplicates. Each feature requires just a few mouse clicks.

Read more here.