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...
Formula Friday – Using COUNTIF Function With Data Validation To Check For Repeating Values In Excel
Hi Excellers, welcome to another #formulafriday blog post in my #Excel 2021 series. Data validation is a great way to control data entry into your Excel spreadsheets. The main positive is to...
Formula Friday – Did You Know Excel Knew Roman?. Convert Numbers To Roman Numerals In Excel
Hello Excellers, today let's have a bit of fun with formulas. Did you know that Excel had a ROMAN function?. No, I did not either. I love when I discover something new. I will show you how to...
Happy Friday and time for more FORMULA FUN on #FORMULAFRIDAY. This article will use the COUNTIFS Function in Excel to calculate how many people are working at the same time in a retail store. Use...