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: formula friday
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...
Hello Excellers and welcome back to another blog post in my Excel tips #Excel #FormulaFriday blog post in my Excel series. A lot of systems (mainframe usually) use Julian dates. This blogpost will...
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...