Formula Friday – 2 Ways To Create A Dynamic Named Range In Excel
Time for some more #formulafriday fun. Today let's look at 2 ways to create a name range in Excel. If you want to read more about using named ranges in your Excel formulas then you can read my...
Formula Friday – Use A VLOOKUP Formula Across Multiple Excel Worksheets
Hi Excellers today let's flex our formula muscles and tackle a VLOOKUP question, how to carry out a VLOOKUP over multiple worksheets in the same workbook. Suppose I have three worksheets with data...
Formula Friday – Top 3 Reasons Not To Use Hard Coding In Excel Formulas
Hi Excellers, it is time for some more formula fun on #formulafriday. Today I want to share with you my Top 3 Reasons Not To Use Hard Coding In Excel Formulas If you want see see all of the blog...
Macro Mondays – A Macro To Create An Alert When A Cell Value Exceeds Its Target Value
Hello Excellers, time for some #macromondays fun again. Today I want to share with you a really small piece of code, that will alert the user when a cell value reaches or exceeds a it's target...
Formula Friday – Calculate The Date Of The Nth Weekday Of The Month
Hello Excellers welcome to more #formulafriday fun, today let's look at a query that is a actually a widely used calculation for a lot of different scenarios- calculating a date of a certain weekday...
Formula Friday – Show A Zero Not Negative Number After Calculating Stock Items – Two Methods
Hey Excellers, one of my favorite times of the week, #formulafriday time!. Today let's look at avoiding Excel displaying a negative number after a calculation of stock items in an...