A you could see inside the screenshot beneath, the formulation operates just fine just after deleting a column; Additionally Excel is wise enough to appropriately regulate absolute references In such cases: Once the scrutinee expression is an area expression, the match isn't going to allocate

Article Under Review