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: formula friday
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...
Back To Basics. Understanding Excel Formula Errors – Formula Friday
Are you ready to get back to basics today with some refreshment of the meaning of the Excel Formula errors that you get sometimes in your worksheets?. It's time to review, and if you are new...