A YouTube viewer asks if there is a way to add the current date to the right of any 'Yes' entries in a s...
Today in Episode #1473, Dueling Excel looks at Scores and Tie Breaking. In this example, Whe...
Herbie has a Calendar spreadsheet being populated by a huge concatination formula. He asks if there ...
Choose random weeks from the Data Set, but do it without repeating a week. In a revisiting #1469, how will...
Patrick has a weekly Expense Ledger Spreadsheet set up; he wants to create a Macro to co...
Shaun has a beautiful spreadsheet to calculate staffing levels and expense.He needs to multiply shift length by the ...
Formulas are ‘changed’ and that the Alpha Columns of the worksheet have been changed to Number...
Can you embed a PDF in a worksheet? Yes - Using the 'Insert Object' Menu Tab. Follow alo...
Gary points out that the TRIM Function in VBA isn't working like =TRIM() Function in the...
Tony needs to keep the last duplicate record and throw out the earlier ones. In Episode ...