Forum Discussion

PPM's avatar
PPM
Copper Contributor
Jan 21, 2026

Excel pads dynamic array output with #NV values

I have come across a couple of instances, where Excel 365 pads the output (of lambdas) or in this case of a specific formula within a lambda with #NV values (or errors if you like to treat them so.) ...
excel
Formulas and Functions
office 365
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jan 23, 2026
=LAMBDA(assemblyName;
 LET(
   filteredParams; {"a";"b";"c"};
   mappedValues; {1;2;3};
   stacked; HSTAPELN(filteredParams; mappedValues);  // 3x2 array
   transposed; MTRANS(stacked);                     // 2x3 array
   return; WENN(transposed = ""; "NV"; transposed); // Dimensions match (2x3)
   return
))("fake")

for eliminating the #NV padding.

Hope it helps 🙂

Resources