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...
Category: Formulas
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...
Hi Excellers, and welcome to another blog post in my #Exceltips #formulafriday 2021 Excel series. Today, let's look at how valuable a TRIM can be. The TRIM function is a really useful function to...