Happy Friday peeps its time for another formula on a Friday. Here is a question I have been asked a few times now, and the answer is not quite what you think. How to find the minimum value in a data range, BUT we want to ignore the zero (0) values. You would automatically (perhaps :-) ) think that you could use the MIN (minimum) function, but this will only find the MINIMUM, so if we have zero in our data range that is what it will return. See my example … [Read more...]

## Formula Friday- Use The Standard Percentage Change Formula.

In this Formula Friady blog post, let's take a look at a the universally used percentage change formula, we will be also plotting it on an Excel chart along with the original or actual values. We will then be be using two data sets and two types of chart to visually represent this data. Phew lets get started!..... Percentage Change ( % change) really is one of the most frequently used and asked about formulas in my experience in working with Excel users. So let's as ever work with an … [Read more...]

## Formula Friday – Use VLOOKUP With MIN Function To Find The Product That Sold For The Lowest Price.

Happy Friday...Fun with formulas time again. Today let's look at a solution to the problem of finding the type of Beannie hat that sold for the lowest price. I have a list of transactional data of sales of Beannie Hats- an extract can be seen below- Let's see how to use the VLOOKUP function to look up the name of Beannie associated with the lowest selling price and combine it with the MIN function. The syntax of VOOKUP … [Read more...]

## Six Common Mistakes Made When Using VLOOKUP Function In Excel

VLOOKUP is like a lightbulb going on when you 'get them' for most Excel users. There is an ah hah moment when they work, but when they do not, it really frustrating especially for rookie users- in particular if there is not a more experienced Excel user around. Whilst it is a great formula it is a bit sensitive and has its limitations but as long as you abide by the rules you should be fine. Here are are my top 6 reasons that a novice VLOOKUP user finds their formula is not doing what they … [Read more...]

## Formula Friday – Calculating A Rolling Or Moving Average Using The OFFSET Function

Calculating moving averages can be a really useful way to look at trends in your data, and we can easily set up a formula in Excel to always look at the last 3 or 6 or any numbers of months in your data. Let's take a look at an example. I want to know the last 3 months average sales of my Beanie Hats. .... ....always the last three months even when my new monthly sales data is added into my spreadsheet. I have entered the number of months I want to use for the … [Read more...]

- « Previous Page
- 1
- …
- 19
- 20
- 21
- 22
- 23
- 24
- Next Page »