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...
Tag: Excel Formulas
Excel Tip- Formula Friday -How To Create a drop down list for your hyperlinks in Excel
Adding a drop down list to your Excel sheet is a really great and convenient way to allow data entry to your Excel worksheets whilst maintaining good quality consistent data and reducing the amount...
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...
Formula Friday – 3 Reasons To Use Named Ranges In Your Excel Formulas
Hey Excellers, thanks for joining me for another #formulafriday. Today I want to share my top 3 reasons to use named ranges in your formulas. There are many benefits to using named ranges in your...
How To Create An In Cell Bar Chart Using The REPT Function In Excel -Formula Friday
Hello Excellers it is Friday again and time for #formulafriday where we have some Excel formula fun. Have you used the REPT function in Excel or ever used it?. It's a bit elusive so let's get it...
Formula Friday- Two Ways To Create A Time Stamp In You Excel Workbook
Do you need to create a timestamp in Excel? You have two methods to choose from. In this blog post, we'll show you how to do it with each method. Read on to learn more! This really is THE most...