Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function
Happy Friday, Excellers. Today let's look at how to generate a unique username in Excel using the COUNTIF function, even when you have duplicates! Welcome back for another #FormulaFriday in...
Macro Mondays – How To Assign Or Change A Macro Shortcut Key
Hello Excellers, time for some back to basics today with Excel Macros. Let's take a look at assigning or changing a shortcut key with a Macro. Yes, welcome back to another #MacroMonday blog...
Hello Excellers, welcome back to another #Exceltip blog post in my 2021 series. Today I will show you how to use flash fill to split your cells into separate columns. Yes, that is correct....
Hello Excellers, welcome back to another #Excel tip in my 2021 series. Today I will show you how to unprotect multiple Excel worksheets quickly. Have you created an Excel workbook with...
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....