Hello Excellers, welcome to another #Excel #FormulaFriday blog post in my Excel series. Today let's explore the UNIQUE function in Excel. This newly released function is part of the...
Category: Blog
Macro Mondays – Unlock ALL Cells In An Excel Workbook With VBA
Macro Monday time and that means some more Excel macros and VBA. Today let's look at a tiny Macro that pulls a punch. Are you a Microsoft Excel user who stares in frustration at your workbook,...
Formula Friday – Find The Date Of The Fourth Business Day Of The Next Month.
Do you find yourself trying to figure out the date of the a specific business day of a future month? If so, you’re not alone. It’s a question that can stump even the most experienced Excel users...
Are you regularly transferring files from one folder to another? Things can quickly become tedious and time-consuming - but not anymore! Excel VBA Macros enable an easy yet efficient way of copying...
In this blog post, I will show you how to easily remove multiple hyperlinks from an Excel workbook. I recently had this question submitted via email from a subscriber. They had a LOT of hyperlinks...
Formula Friday – Two Ways To Highlight Today’s Date In Your Excel Dataset
Hello, Excellers. Welcome to another instalment of #formulafriday. Today let's look at here a handy Excel Tip if you want to highlight today's date in your Excel data set. I have...