Formula Friday – Randomly generate words in Excel with INDEX and RANDBETWEEN.
Are you looking for an easy way to randomly generate words in Excel? If so, you’re in luck! Using a combination of the INDEX and RANDBETWEEN functions together with some creative data entry...
Macro Mondays – How To Add A Break Point To Your Excel VBA Code
Hello, Excellers. Welcome to another #MacroMonday blog post in my Excel series. Today let's look at breaking up our VBA code by adding a breakpoint to your Excel VBA code. If you're an Excel...
Hello Excellers and welcome back to another blog post in my series of #FormulaFiday #ExcelTips. Today, let's answer an Excel question from one of my subscribers. They want to be able to delete...
Formula Friday – Why is my formula showing in a cell and not the result??
Hello Excellers. Welcome to another blog post article in my #Excel series. When you create a formula in Excel, you may expect to see the result of that formula immediately show up in the cell where...
Happy Friday Excellers. Today I want to share with you how to RANK a data set with the rank formula in Excel, but ignore zero values. I use RANK a LOT, and sometimes you just do not want to...
Formula Friday – How To Use The DAY Function In Excel With Examples.
Happy Friday Excellers time for more #formulafriday fun. Today let's look at using the DAY() function. In Excel, the DAY function calculates the day of the month for a given date. This function is...