MrExcel

Learn Excel – “200 Checkboxes in Excel”: Podcast #1871

               

Catherine is building a risk assessment tool in Excel. She needs to add 200 checkboxes to a worksheet, but this is Back

Learn Excel – “Tardy 4 Times in 8 Weeks”: Podcast #1870

               

Sunnee asks if there is a Formula for identifying people who were tardy more than three times within an eight week period. Provided the Data is sorted from earliest to latest, Back

Dueling Excel – “Who Has Not Signed”: Podcast #1869

               

Today’s Podcast is Duel #155: “Trying to write an insane Formula to solve another poorly formatted Spreadsheet.” Back

Learn Excel – “Self-Maintaing Lookup Table”: Podcast #1868

               

Enter a product on Sheet 1. You want a VLOOKUP Formula to grab the description from a Lookup Table on Sheet 2. However, if the product is missing from Back

Dueling Excel – “Category and Settings in Same Cell”: Podcast #1867

               

Every once in a while, you run into ugly Data Sets and this one qualifies.  In ‘Dueling Excel’ Episode #154, we find that someone decided it would be brilliant to Back

Learn Excel from MrExcel