Formula Friday – Convert All Of Your Text To Upper Case Using…You Guessed It The UPPER Function
Hello Excellers. I love Friday Formula time. Don't forget to #followfriday on Twitter...... This is a really useful formula, and one that a lot of Excel users dont use that often, in fact,...
Formula Friday – Create A Dynamic Pivot Table Data Source Using OFFSET and COUNTA Functions
Happy Friday Excellers..... Pivot Tables are great for taking hundreds or even thousands of rows of data and be able to summarise and analyse your data set with a few clicks of your mouse, if...
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...
Happy Formula Friday!. This Friday we are a bit stuck in the middle, yes you guessed it - its MEDIAN time. As you probably know, the MEAN is a useful way to summarise a group of numbers. But...
Hi guys, this is a new type of post for me Formula Friday. Every Friday I will blog on a formula or function in Excel. I'm looking forward to this new posting schedule. Today's post will be the...
This tip is one my most favorite time savers when using Pivot Tables- the ability to create many reports with just a few mouse clicks. The scenario for this example is the national sales manager...