No, you’re not going mad, it’s just Excel’s Implicit Intersection
For many years there has been something kooky going on in my Excel worksheets. It was this strange phenomenon that from time to time would rear its head. I never had a name for it, I just knew it existed. Then one day a 3 minute video from MrExcel ended years of wonder and finally …