Posts tagged ‘Max’

Learn Excel 2013 – “Is 26×26 Letter Grid, No Repeats Impossible?”: Podcast #1701


Can We…Will We Finally Prove This: Possible / Impossible? Yes.

Advertisements

Continue Reading May 2, 2013 at 2:37 pm

Learn Excel 2013 – “26×26 Letter Grid & No Repeats-Both Ways?”: Podcast #1700


Testing Math and Probability Skills…and More!

Continue Reading May 1, 2013 at 12:50 pm

Dueling Excel ‘Almost Live’ – “Unfinished Projects”: Podcast #1536


Dueling Excel Podcast 103…or is it 102? It’s Almost Live Late at Night!

Continue Reading March 31, 2012 at 4:05 pm

Episode 756 – Meal Rollover


A question from a recent seminar involved calculating how many unused meals occurred during a month. The person had to rewrite several formulas every month depending on the total number of days in the month. In Episode 756, we’ll take a look at some changes to allow that formula to work for every month.

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

May 12, 2008 at 9:00 am Leave a comment

Episode 747 – Who is Largest


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.

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

April 29, 2008 at 9:00 am Leave a comment

Episode 736 – Index Match


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.

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

April 14, 2008 at 9:00 am Leave a comment

Episode 348 – Max or If


Calculate Sales over Quota using either the IF or MAX functions. Episode 348 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!

September 26, 2006 at 9:00 am Leave a comment


Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 742 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive