Learn Excel Episode 736: Index Match

Posted in Companies, Podcasts on July 15, 2008

Jon has a follow-up question about his baseball spreadsheet. After calculating the win and loss streaks, he would like to find the longest streak, including the start and end dates. This seemingly simple question requires two completely useless functions. Once these functions are used in conjunction, they become very powerful. Episode 736 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Formulas, INDEX, MATCH, Max