Hello Excellers, welcome back to another #FormulaFriday #Excel blog post in my Excel 2021 series. Do you need to know how what discount has been applied to a product?. If you need to calculate the...
Tag: Excel Formulas
Hello Excellers welcome back to another #Excel #FormulaFriday in my 2021 series. Today I want to show you how to extract the first letter of a first and second name without using Excel formulas. We...
Hello Excellers, welcome back to another #Excel #FormulaFriday blog post in my 2021 series of Excel formula tips. So, due to a colleague asking about the GETPIVOTDATA function (which seemed to cause...
Formula Friday – Easily Identify Cells That Begins With A Specified Letter in Excel
Hello, Excellers. It is Formula Friday time again!. Do you need to identify with conditional formatting cells that begin with certain letters?. Today I will show you how Excel can easily identify...
Formula Friday – Prevent The Divide By Zero Error In Excel #DIV/0!
Hello, Excellers. So, welcome back to another Excel blog post in my #Excel Formula Friday 2020 series. Today, we deal with a formula error. Let me show you how to deal with the #DIV/0!, divide by...
Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my Excel 2020 series. Today I want to show you how to not only hide your Excel formula from users but lock those cells. ...