I download a lot of data form various sources, so the quality and formatting of it can vary significantly.  One issue that occurs a lot of the time is a date field being formatted as text.  It...

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...

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. ...

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...

          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...