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...
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...
Hello, Excellers. It is Friday and that means some more #FormulaFriday Excel fun right?. If you need to number your table rows sequentially then this is the Excel tip for you. So, if you sort...
Hello, welcome back to another blog post in my 2021 series. I want to share with you a favourite Excel tip of mine. I think you will like this Excel formula bar tip. This Excel tip is...