Monthly Archives: January 2013

Installing Office 2013

Today I finally got round to installing Office 2013 Pro Plus (x86), Visual Studio 2012 Ultimate and SQL Server 2012 Enterprise Edition (x86). The order I installed them in is as listed because in the past I’ve found that installing Visual Studio … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , | 5 Comments

Count Distinct, Unique And Successive Values Using FREQUENCY()

Happy New Year, folks! And now, without further ado… In my opinion, one of the hardest worksheet functions to get the hang of is the FREQUENCY() function. For today’s post, I’ve assembled a collection of FREQUENCY() formulae which give a count of distinct, unique … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , | 16 Comments