Learn Excel 2010 – “Count Red Rows”: Podcast #1687

Count the Total Number of Rows containing Colored Cells.

Learn Excel 2010 – “Filter to Unique?”: Podcast #1500

Use the Advanced Filter to show one record per customer.

Learn Excel 2010 – “Sum Red”: Podcast #1415

Sum – by color! A Simple Macro will do the trick for you!

Duel 77: Top 2 by Industry: Podcast #1394

Duel Number #77 with Mike and Bill…

Learn Excel – Top 3 by Letter: Podcast #1376

Isolate the top 3 values for each letter of the alphabet in Alpha Order! Its Easy!

Dueling Excel – Remove Zero Records: Podcast #1332

Remove some records, retain what you need and learn a little VBA Today!

PowerPivot 2010 – DAX Measures: Podcast #1327

DAX Measures and Custom Filtering in PowerPivot 2010

Excel Rev Up – Filter Search: Podcast #1321

Combine Keywords to display results using ‘Filter Search’ . . .

Filter Dropdowns: Podcast #1310

Move the AutoFilter dropdowns from row 1 of your worksheet . . .

PowerPivot – Top 10 Report: Podcast #1300

Use Excel and PowerPivot to Slice, Filter and Present your data your way . . .