Until you know this setting in Excel, it is difficult to see how you can have great looking static images on your Excel sheets. Being able to lock down your images on a dashboarrd for example to...
Tag: Excel Tips
It can be really frustrating if you have set up your VLOOKUP formula, all is working great and then you have to manually adjust the formula if you want to copy it across multiple columns. See my...
Formula Friday -Using The Workday Function To Calculate Status Of An SLA
I dont know about you, but our IT department at work has an SLA turnaround time of 8 days. That is 8 working days, so we can't really chase them for any updates until that time has elasped. ...
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...
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...
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...