Formula Friday – Find The Minimum Value In A Range But Ignoring 0 Values
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...
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...
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...
Happy Friday Exellers . You may have already come across this problem, and if you have not, you probably will at some point when using Excel. The mysterious case of your formula is showing in the...
Formula Friday – How Many Sales People Have Above Average Sales Using COUNTIF Formula
Hello Excellers, welcome to some more Formula Fun on a Friday. In my scenario today, I need to know how many sales force members earn higher than the average sales. One of the quick ways to do this...
Formula Friday – Use Approximate Match In VLOOKUP Apply Grading To Student Papers
Excellers, it's time for more Formula Fun. Today I am going to show you how to use the approximate match in the VLOOKUP formula to apply Grades such as A,B,C,D etc to student papers dependant on...