At the beginning of the video, we make a tweak to the code to 'shift' the away form over to the right. Et, voila!  A complete form analysis generation routine, with all the results in the right place.  Take the time to test it, then, if you've got it working, run it a few times and appreciate the power of VBA.  It really is a thing of beauty ...

But, is this routine complete?  A few things are missing. What about clearing out previous analyses, for example?  Then, surely we'd want some colouring on the form analysis to give a 'traffic light' feel?  Also - what about some 'summary' analysis: counting up the number of wins, losses and draws, and generating an average points value?

Next, we set about creating the summary analysis using a new facility for the form analysis series - application.worksheetfunction.  Should you use this all the time for calculations in Excel?  Probably not.  But, applied sparingly, it's incredibly powerful and we cover a simple example in this video - with a more difficult 'homework' challenge revealed at the end.  Will you take it on?!

Tools And Techniques

- Concept of 'increment' variable
- Advanced position control
- Using breakpoint to debug
- COUNTIF formula
- Partial absolute reference ($)
- Introduction to application.worksheetfunction
- Application.worksheetfunction with COUNTIF