Hello Excellers and welcome back to another #FormulaFriday #Excel blog post in my 2019 series. Do you ever need to jump to today's date in your Excel workbook?. Do you manually scroll along?. In...
Category: Formulas
Find The Excel Cell Address Of The Maximum Number In Your Data Set.
Hello Excellers and welcome back to another #FormulaFriday #Excel blog post in my 2019 series. This week I will show you how to find the Excel cell address of the maximum value in your data set. ...
Do My First n Characters Of Each Row Match In Both Columns?.
Hello Excellers and welcome back to another #FormulaFriday #Excel tip in my 2019 series. So, today let's tackle an Excel question asked by a subscriber to my Monthly Newsletter. They needed to...
Find The Excel Cell Address Of The Maximum Number In Your Data Set
Hello Excellers, welcome to another blog post in my #Excel Tips, #FormulaFriday 2019 series. Today, let's take a look at how to find the address of the cell that contains the maximum number in your...
Formula Friday – SUM Only NEGATIVE Numbers In An Excel Range Using The SUMIF Function.
Happy Friday Excellers. It's #formulafriday time therefore time for another blog post in my Excel series. Today let's look at counting all of the negative values in a data range. This formula is...
Add Decimal Places To An Existing Data Set – No Formulas Needed.
Hello, Excellers welcome back to more #FormulaFriday #Excel fun. Today let's look at how to add decimal places to a dataset of existing numbers. Really quickly. (Without using a formula). Here is...