We’ve talked, at length about Excel’s Rank()/Rank.EQ functions and coping with joint or equal rankings. What about Rank.AVG()? Rank.AVG() works differently for equal rankings because it returns an average of the combined rankings. For example, joint 3rd place getters will return the value ‘3.5’ by Rank.AVG() which is the average of ranks 3 and 4 […]
Rank() and Rank.EQ() are fine while each value/score is different but in the real world you’ll see cells with the same value and ranking. We’ll show you how to detect equal rankings, display a note when there are equal rankings. Let’s start with an example of equal rankings. See Venus/Vulcan in this example, both have […]
While Microsoft is busy patching for the Spectre/Meltdown chip flaws there’s another serious and more easily abused security flaw in Word. It’s fairly simple and not yet detected by any of the anti-virus programs. It’s called ‘SubDoc’ and was discovered by Rhino Security Labs who have gone to the extent of creating a tool to […]
So many patches for Microsoft Office and Windows in this month’s package of bug fixes. Few parts of Windows or Office aren’t patched this month, either directly or indirectly. According to Microsoft there’s ‘only’ 56 patched security holes in their products, this month alone. In reality there’s a lot more patching going on, just how […]
When you update your Outlook rules with Exchange Server, why does it take so damn long and you have to wait? Each time you change your email processing rules, Outlook for Windows/Mac has to update the server. But it takes an unreasonably long time, even when there’s only a few rules being updated across a […]
