Formula Friday – Why is my formula showing in a cell and not the result??
Hello Excellers. Welcome to another blog post article in my #Excel series. When you create a formula in Excel, you may expect to see the result of that formula immediately show up in the cell where...
Happy Friday Excellers. Today I want to share with you how to RANK a data set with the rank formula in Excel, but ignore zero values. I use RANK a LOT, and sometimes you just do not want to...
Formula Friday – How To Use The DAY Function In Excel With Examples.
Happy Friday Excellers time for more #formulafriday fun. Today let's look at using the DAY() function. In Excel, the DAY function calculates the day of the month for a given date. This function is...
Formula Friday- Excel Tip- Generate Random Numbers With Excel.
Do you need to generate random numbers for a project? Excel can help. This guide will show you how to use the RAND and RANDBETWEEN functions to create random numbers in Excel. You can also learn some...
Hey All, it's Formula Friday again. Today let's look at a handy little formula called DATEDIF. DATEDIF is a function in Excel that calculates the difference between two dates. It can be used to...
Formula Friday – Let’s Use TEXTJOIN To Join Text Strings Without The CONCATENATE Complexity
Happy Friday Excellers. Welcome back to another #FormulaFriday #Excel blog post in my Excel series. I will compare TEXTJOIN and CONCATENATE. If you have Excel 2016 then you may be...