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 […]
Back in Excel 2007, Tables were added. That simple name hides a quite different and powerful Excel option that, in our view, Microsoft hasn’t explained very well. Excel is often used for lists and Excel Tables make managing and extending those lists a lot easier. In fact, ‘Excel Lists’ was the name of the Tables […]
