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...
Convert Positive Numbers To Negative Numbers Using Paste Special Trick
Hello Excellers, welcome back to another #Exceltips blog post in my 2021 series. I wanted to share this Excel tip with you as it really is a fast way of converting a list of positive Excel numbers...
Formula Friday – How To Delete Values From Cells But Keep Your Formulas In Excel
Hello, Excellers. Welcome back to another #ExcelTip blog post in my Excel 2021 series. It is time for a neat Excel trick today in today's #formulafriday blog post. I will demonstrate how to...
Macro Mondays – Convert A Range Of Cells To Upper Case With An Excel Macro
Hello, Excellers. Welcome back to another #MacroMonday blog post in my #ExcelTips series for 2021. You may or may not already know how to convert all text to upper case in Excel by using the UPPER...