Today, in our latest Dueling Excel feature, Mike and Bill have Data to work with, but the idea behind the use of the Data becomes very odd. For Each Letter Group in a Cell, there is a designated Numeric Value for each Letter that needs to be found, applies and then the Data will rationalize. Follow along with Episode #1667 as Mike “ExcelisFun Girvin and Bill “MrExcel” Jelen sort this out and achieve the result.

[youtube=http://youtube.com/watch?v=2Ygn4E2JmvE]

Dueling Excel Podcast #110…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!