Naming a row of data creating spill error

%3CLINGO-SUB%20id%3D%22lingo-sub-2167015%22%20slang%3D%22en-US%22%3ENaming%20a%20row%20of%20data%20creating%20spill%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2167015%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20to%20be%20able%20to%20name%20several%20cells%20of%20data%20in%20a%20row%2C%20use%20the%20named%20row%20in%20a%20formula%2C%20then%20add%20in%20extra%20details%20into%20specific%20cells.%26nbsp%3B%20This%20now%20leads%20to%20a%20%23spill!%20error%20as%20the%20named%20row%20now%20appear%20to%20be%20a%20dynamic%20array.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20go%20back%20to%20the%20old%20way%3F%26nbsp%3B%20ie%20static%20array%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2167015%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I used to be able to name several cells of data in a row, use the named row in a formula, then add in extra details into specific cells.  This now leads to a #spill! error as the named row now appear to be a dynamic array.  

 

How do I go back to the old way?  ie static array?

1 Reply
It is an array in both cases, just old Excel performed silently in background implicit intersection, that's not the case for the new Excel. More about this here https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1...
You may try to use "@" in front of your formula, or better re-write it in dynamic arrays style.