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...
In Today's #FormulaFriday #Excel tip in my 2019 series let's look at how to sort your data set in random order. We will do this using the RAND Function. This is a really handy tip if you have...
Hello, Excellers welcome to another blog post in my 2019 #FormulaFriday #Excel tips series. Today let's take a look at creating a formula or a calculation within an Excel Pivot Table. If you...
Hello, Excellers and welcome back. It is Friday Formula time again. Today's post will look at how to use wildcards in a VLOOKUP formula. Let's begin with an example to demonstrate the...