ExcelIsFun

Dueling Excel – “Split a Contract over N Months”: Podcast #1860

               

Today, in Dueling Excel Episode #152, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen look at Splitting a Contract Period. Back

Dueling Excel – “LOOKUP First Over 100”: Podcast #1855 / Duel #150

               

Wow. 150 Dueling Excel Podcasts and counting! Wouldn’t it be nice if you could do =VLOOKUP(>100,MyTable,-1,False)? Back

Dueling Excel – “Dateify with 0000\/00\/00”: Podcast #1840

               

In today’s Dueling Excel Podcast #145, the goal is to use a Formula to convert 20131220 to a real Excel Date. Back

Dueling Excel – “Prevent VLOOKUP from Returning Zero” – Podcast #1750

               

VLOOKUP Tricks and Another New DVD from ‘ExcelIsFun’!

Learn Excel – “Array Formula to Extract Records” – Podcast #1746

               

Extracting Records, New Books and Lots to Do!

Learn Excel from MrExcel