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...
Tag: Excel
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...
Add 5% to my Sales Targets Without Using Extra Columns Or Cells
Hello, Excellers. welcome to another blog post with an #exceltip in my 2019 #formulafriday series. Today I want to share with you how to carry out a calculation with no excel formula, and no...
Excel Formula Friday – Using Find And Replace To Quickly Change Formulas
Welcome Excellers to another #formulafriday blog post. Today let's take a look at how to quickly change your Excel formula without having to rewrite any of those formulas. I have...
Happy Friday Excellers. Time for some more Formula Fun. Today I want to show you how to use SUMIF in Excel to sum only the POSITIVE numbers in your data set. Let's take an...