International
You can solve the MWF problem from episode 1018 using an incredible array formula from the book Excel Gurus Gone Wild. Episode 1019 takes a look at how to coerce an array of dates from a start date and end date cell.
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!
Rated 3.72 | 117 Views
By MrExcel
Rated 5.00 | 4 Views
By MrExcel
Rated 3.29 | 191 Views
By MrExcel
Filling Quarters - 1132 - Learn Excel from...MrExcel Podcast
Rated 0.00 | 5 Views
By MrExcel
Fiscal Quarter UDF - 1033 - Learn Excel fr...om MrExcel Podcast
Rated 4.81 | 49 Views
By MrExcel
Timestamp - 1106 - Learn Excel from MrExce...l Podcast
Rated 4.98 | 6 Views
By MrExcel
Opening Balance VLOOKUP - 1115 - Learn Exc...el from MrExcel Podcast
Rated 2.84 | 84 Views
By MrExcel
ADM Calculation - 1133 - Learn Excel from...MrExcel Podcast
Rated 0.00 | 10 Views
By MrExcel
Link Formatting - 1057 - Learn Excel from...MrExcel Podcast
Rated 3.68 | 193 Views
By MrExcel
Duel: Multiple Wildcards - 1090 - Learn Ex...cel from MrExcel Podcast
Rated 3.24 | 106 Views
By MrExcel
Duel: Earliest Matching 2 - 1104 - Learn E...xcel from MrExcel Podcast
Rated 3.25 | 94 Views
By MrExcel
Duel: Index:Index - 1134 - Learn Excel fro...m MrExcel Podcast
Rated 0.00 | 19 Views
By MrExcel
Icon Sets Data Bars - 1069 - Learn Excel f...rom MrExcel Podcast
Rated 3.67 | 221 Views
By MrExcel
2010 Backstage - 1076 - Learn Excel from M...rExcel Podcast
Rated 4.54 | 34 Views
By MrExcel
Both Versions? - 1081 - Learn Excel from M...rExcel Podcast
Rated 3.05 | 122 Views
By MrExcel
2010 Picture Tools - 1088 - Learn Excel fr...om MrExcel Podcast
Rated 3.14 | 133 Views
By MrExcel