Viewing profile — jamses

I tried and failed to learn to juggle three balls many times, I've just got terrible coordination. But one day I stood over a bed and just threw them in the air and listened to the…

This was great fun. The race to Rome says it's to the colosseum, but it's actually pointing to a roundabout near Termini station :) How on earth are people managing in 5 hours thou…

Ctrl+` will show the underlying formula, or you could use conditional formatting to apply whatever style you want to static values =NOT(ISNUMBER(FIND("=",FORMULATEXT(A1)))), or you…

For a summary of news I look at https://emm.newsbrief.eu

I've never seen that particular claim about the museum - it was set up to hold Sloane's collection alongside the Cottonian and Harleian libraries. Where is it from? Is this a misre…

I'd guess war is usually excluded from insurance policies. I wonder if the 1 in 200 year example wasn't communicated very well; it could be the actuaries view a long-lasting 10% in…

Article lead: The overall risk of children becoming severely ill or dying from Covid is extremely low, a new analysis of Covid infection data confirms. As far as I can tell the lin…

Not quickly by land, but you could travel far enough by sea.

This should work on windows - I'm not sure about Macs: you press and hold the ALT key, then right-click the Excel icon in the Windows taskbar and click the Excel icon above the tas…

You can open separate Excel instances by holding ALT when starting it up (second time onwards). Not quite the same thing as you want, but think the undo behaviour you describe make…

I suspect your example is only for context, but just in case it saves you time in future, if you can sort the data first then you can use something like: if(vlookup(value,range,1,T…

I found early-on that MOOCs were terrible for learning because of the barriers they put up. Locked-in time schedules, a trend towards very short "bitty" and simplistic videos that …

I wouldn't worry that it's your failure, you're just not into it. I loved Windup Bird Chronicle. I struggled with 1Q84. I find the same thing in every creative field (art, film, li…

I think the high-bar that you desire is less user friendly and more designer-job-friendly. - Here the information you're probably after is right at the top: letters from the CEO, a…

Mortality-wise it looks to be around 20x worse than flu, and easy to spread before outward symptoms manifest. There's no vaccine, so the usual partial herd immunity isn't present, …