Duel: Multiple Wildcards - 1090 - Learn Excel from MrExcel Podcast

In today's dueling Excel podcast, the question is how to delete all the records which contain either ski or swim. This requires multiple wildcards in a filter. Mike and Bill will compare various methods in Episode 1090 .

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 #1002 - Multiple VLOOKUP

Peter asks how to return multiple records from a VLOOKUP. In Episode 1002, I will show you how to use an Advanced Filter to achieve this result.

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!

Episode 871 - Finding Dates

Someone tried to record a macro to find the records from a certain date. Since finding dates requires the date format to match exactly, a better way to go would be using Advanced Filter. In Episode 871, I show how to use AdvancedFilter in a macro to extract records from a certain date.

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!

Episode 500 - 500!

As we hit this milestone, you can win one of a treasure trove of prizes, including a video iPod, great books from QUE, and more. There are over 40 prizes in all. Also in Episode 500, I draw the winner for the March/April challenge of the month, using a combination of Advanced Filter, INDEX, and RANDBETWEEN. I will use a similar method to award the prizes from our podcast #500 giveaway.

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!