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...
Tag: formula friday
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...
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. ...
Hello Excellers and welcome back to another #Excel tip in my #FormulaFriday 2020 series. Need to get a reminder in Excel?. Today, let's look at using the NETWORKDAYS function to get a reminder in...
Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my 2020 series. Today I will show you to use a dynamic column reference with the VLOOKUP formula. Working with large...
Hello, Excellers. Welcome back to another #FormulaFriday #Excel blog post in my Excel 2020 series. Today I will show you two ways in which you use Column and Row labels as named ranges. About...