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 – Create A Dynamic Report Header Using The Concatenate Function
I like to automate processes as much as possible and creating report headers for updated monthly reports are no exception to this. If you have the same headers every month, but only the Month name...
Friday Formula Fun Time..... Do you find that your VLOOKUPS are sluggish sometimes when you are dealing with larger data sets?. Here is a way to speed them up....use 2 VLOOKUPS at a...
Formula Friday- Automating Cell Updates With VLookUp Formula And A Drop Down List
Friday again Excellers...Formula Friday time. Today let's look at how to save time entering data into workbook, by using both a VLOOKUP formula and a data validation drop down list. I want to...
Formula Friday – Easily Spot Excel Formula Errors In A Large Excel Worksheet
It's Friday yet again, time for some Formula Fun.....Let's take a look at finding formula errors today. If you have a really large worksheet you may not be able to look at it all at once...
Formula Friday – How Excel Calculates – The Order Of Excel Calculations
If you plan on writing formulas in your Excel spreadsheet- I am assuming you do want to use Excel for calculations at this stage :-) then knowing the order of precedence or that Excel performs the...