Wed, 21 December 2011
A small company has decided to start doing Random Drug Testing. They want to randomly select two (2) employees each month. In Episode #1491, Bill builds a handy Workbook for this task. Enter the Employee Names in B2:B101, then press F9 to select two (2) employees for the month. The Randomization is done with formulas – no VBA. *Oh No! Podcast #1490 never launched; we apologize for the misfire!* …This episode is the video podcast companion to the book, “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! |
Bill Jelen

