Duel: Eval Text Formulas - 1149 - Learn Excel from MrExcel Video Podcast

Someone put a bunch of mathematical calculations in column A as text and we want to evaluate those formulas. Mike and Bill provide dueling ways to solve this problem in Episode 1149.

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!

Duel: 2-Way Lookup - 1124 - Learn Excel from MrExcel Podcast

Mike & Bill take a look at various ways to do a 2-way lookup in this dueling Excel Episode 1124.

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!

Duel: Rejoin WordWrapped Cells - 1119 - Learn Excel MrExcel Podcast

External data pasted into Excel shows up with 1 row in columns A & C, but multiple rows in B. Today's dueling Excel Episode 1119 shows how to deal with this data.


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!

Duel: Matching Prospects - 1109 - Learn Excel from MrExcel Podcast

BackIn2Shape at YouTube has two worksheets; one of customers, and one of prospects. If a prospect is on the customer list, he would like to delete it. Episode 1109 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!

MrExcel's Learn Excel #980 - Dueling: Wildcard Match

Mike Girvin and Bill Jelen meet up again to offer three solutions to the problem of counting how many records match a wildcard criteria. Episode 980 shows you how.

This video is the 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!