Forum Discussion
BYROW and LAMBDA combo Autocomplete/IntelliSense Broken for LAMBDA
As you know, when you type a function, starting with the equal sign, the IntelliSense brings up a list of functions and you can tab to autocomplete, then Excel recognizes the function and offers screen tips for the arguments. However, the LAMBDA function IntelliSense, when used with the BYROW and BYCOL functions, does not do this. This problem is across every version of Excel 365. I have tested with and without beta, enterprise, home, insider, no insider. Excel never recognizes the LAMBDA function until you spell it completely and add an open parenthesis, and ONLY when behind BYROW or BYCOL functions. REDUCE, SCAN, and MAKEARRAY functions work fine. LAMBDA by itself also works fine. Only behind the BYROW and BYCOL functions does it have the problem.
3 Replies
In Excel for the web it works as expected.
BYCOL (NACHSPALTE in german)
BYROW (NACHZEILE in german)
OliverScheurich In this desktop picture is the problem. The LAMBDA autofill never occurs when inside the byrow or bycol functions.
- Yes, the BYROW and BYCOL work fine. The problem it is when you type the LAMBDA function inside of the BYROW or BYCOL functions. This problem is only on the application side. The web version appears to be fine.
