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...
Hello Excellers, Welcome to another blog post in my #FormulaFriday #ExcelTips series. Today I will show you how to create a Month to Year calculator in Excel. I have a sample file below to work...
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...
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...
Formula Friday -Delete Values From Cells While Keeping Formulas.
Hello, Excellers, and welcome back to another Excel #FormulaFriday blog post in my 2021 series. Today let’s look at how to delete values from cells while keeping the formulas. A popular...
Do you need to insert a timestamp in Excel? This question is one of THE most requests I receive on a regular basis. Although there is no built-in function or process in Excel to insert a...