Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Thursday, October 18, 2007

Episode 615 - Filter Recent II

In today’s podcast, I address the same question from podcast 614, but assume that the dataset can not be sorted. This requires a powerful array formula to find the most recent date for each customer. Episode 615 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!