Hello Excellers, welcome back to another #MacroMonday blog post in my 2021 series. Today I will show you how to create your very own Excel Function. This Excel function will allow you to extract...
Posts by Barbara
Find The First And Last Occurrence Of A Value With MINIFS and MAXIFS Functions.
Hello, Excellers. Today's blog post will show you how to find the first and last occurrence of a value. I recently used this method to query the first and last dates that a product appeared in my...
Hello, Excellers. Welcome to another blog post in my Excel series. Today I will show you how to create a fun Excel Waffle Chart. Unfortunately, Excel does not have a Waffle chart in the charting...
Use The Status Bar To Find The Maximum Value In Your Excel Data Set WITHOUT a Formula.
So, Hello Excellers, and welcome back to another #formulafriday blog post. Today is a little different as this blog post centers in the Excel status bar. That is correct, We will not be...
Hello Excellers, welcome back to another blog post in my #Excel #MacroMonday series. Today let's write our own Excel macro function that will generate a random string of characters. This random...
Hi, Excellers. Welcome back to another blog post in my new year of 2021 #MacroMonday Excel series. Today let's take a look at how to enable macros and also disable Macros in Excel....