Learn Excel Episode 747: Who is Largest

Posted in Companies, Podcasts on July 15, 2008

Lucy sends in a question. She has built a table of sales by rep by day. She used the MAX and MIN function to find the largest and smallest value. However, her boss then wants her to identify who had the largest and smallest value. This requires the use of INDEX, MATCH, and a couple of hidden columns. Episode 747 will show you how.

Watch Video Watch Video on External Site

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