PivotTables can do more than you think, from splitting reports by category to calculating unique counts and percentage growth ...
Using Excel 2010. I've got one sheet in particular that I'm working with that's got >6400 rows. Column A contains 1,522 unique dates, which range from 4/12/2000 to 10/19/2012 (not inclusive of all ...