Formula Friday – SUM Only NEGATIVE Numbers In An Excel Range Using The SUMIF Function.
Happy Friday Excellers. It's #formulafriday time therefore time for another blog post in my Excel series. Today let's look at counting all of the negative values in a data range. This formula is...
Use The EXACT Function To Force Upper Case Data Entry Into Excel
Hello Excellers, a warm welcome back to another #formulafriday blog post. in my 2019 series. The Excel formula tip today is a recent favorite of mine at the moment, trying to get users to enter...
Formula Friday- Prevent Duplicate Data Entries With COUNTIF Formula And Data Validation
Happy Friday!...time to Excel with another #formulafriday blog post in this series. Today let's take a look at how to prevent duplicate name or employee ID numbers in a worksheet. So, how do we...
Formula Friday – FLOOR Function In Excel- Find Out The Decade That Song Was From
Happy Friday Excellers and welcome to another #formulafriday blog post. I found this little Excel formula out by accident. I was trying to find out what decade a date was from and thought it may...
Hello and welcome to yet another #formulafriday blog post. I want to share today with you an Excel formula problem a colleague of mine asked me to look at a week or so ago. So, I thought it would...
Hello, Excellers. Today's blog post in the #formulafriday continuing series is a little bit different. Usually, we discuss formulas, it is Friday after all! Today though we will discuss how to...