Hello Excellers time for more #formulafriday fun. Ever need to know how much you need to score on your last assessment to reach your target score so you know exactly how far away you really are from passing your assessment? Let's take a look at a working example. Let's say there are four parts to your assessment based on Excel, Word, PowerPoint and Access. Part 1 represents your Excel assessment Part 2 represents your Word assessment Part 3 represents your PowerPoint … [Read more...]

## Formula Friday – 2 Ways To Create A Dynamic Named Range In Excel

Time for some more #formulafriday fun. Today let's look at 2 ways to create a name range in Excel. If you want to read more about using named ranges in your Excel formulas then you can read my more in depth blog posts below. Formula Friday – 3 Reasons To Use Named Ranges In Your Excel Formulas Named Ranges As A Constant Value Using Column and Row Labels As Named Ranges But back to today where we will be exploring two methods of making named ranges dynamic. What do we mean by … [Read more...]

## Formula Friday – Use A VLOOKUP Formula Across Multiple Excel Worksheets

Hi Excellers today let's flex our formula muscles and tackle a VLOOKUP question, how to carry out a VLOOKUP over multiple worksheets in the same workbook. Suppose I have three worksheets with data sets in all of them, each corresponding to a months worth of invoice data. I want to lookup a range of invoice numbers and return the value for each of them, and they could be in any of three invoice data worksheets in my Excel workbook. Let's do a quick recap of the VLOOKUP Syntax The Syntax … [Read more...]

## Formula Friday – Insert The Current Filename And Path In A Cell Using the CELL Formula

Hello Excellers and welcome to another #formulafriday today let's look at a request I have had from a reader, and that is to insert the file path and name of the file in a cell on the front of a workbook (or the first sheet). This actually is a really useful piece of information, to know exactly where your file is saved either locally or in a network location. I use this a lot as would have a need to know if my files are locally stored or on a shared drive using multiple report folders on a … [Read more...]

## Formula Friday – Show A Zero Not Negative Number After Calculating Stock Items – Two Methods

Hey Excellers, one of my favorite times of the week, #formulafriday time!. Today let's look at avoiding Excel displaying a negative number after a calculation of stock items in an itinerary. This again is another discussion I had with an Excel user recently, they only needed Excel to display a zero (rather than the actual negative value) if the result of the calculation of stock in and out resulted in a negative value. So, let's flex our formula fingers, as there were a couple of ways … [Read more...]

- « Previous Page
- 1
- 2
- 3
- 4
- 5
- 6
- …
- 15
- Next Page »