Mike Girvin

Dueling Excel – “When Project Finished, Mark All Green”: – Podcast #1877

               

Today in Duel 157, Mike and Bill look at completed project records. If any record for the project is marked Back

Dueling Excel – “Unmatched Debits & Credits”: Podcast #1872

               

In Duel #156 we have a list of debits and credits. For each amount, match it with the next matching negative amount. After doing all of the matches, 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

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

Dueling Excel – “List All Day Numbers In A Date Range”: Podcast #1864

               

Given a start date and an end date, how do we produce a list of all the Day Numbers? For example, between Feb 28 and March 5 Back

Learn Excel from MrExcel