How to find the minimum value in a range while ignoring the 0 value



In this example we cannot use the function Min (Minimum), because it will only find the smallest value in a range of cells. However the Small Function allows you to choose the Smallest and also the second smallest, third smallest and so on. READ MORE

What you didnai??i??t know about the Format Painter



Format Painter is a great tool, it can be used in any of the Office Applications, it allows you to copy formatting from one area/object to another, but did you know that’s only half of what it’s capable of? What if you need READ MORE