3 ms·
Excel supports reusable lambdas: https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67 https://support.microsoft.com/e
by azhenley 3y ago
Excel supports reusable lambdas: https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67 https://support.microsoft.com/en-us/office/lambda-function-b...
- skissane 3y agoLambda support in Excel is quite new though, isn’t it? If the argument is “Excel is a proper programming language because it now supports lambdas”, that implies that for most of its existence it hasn’t been one
- wizzwizz4 3y agoWe've had VLOOKUP for a while.
- paulddraper 3y agoThat's a dictionary, not a general function.
- baq 3y agoit works well enough in discrete domains... it's literally the definition of a function - map something to something else.
- paulddraper 3y agoYes, a function is an injection [1]. Abstractly. Listing all possible inputs with their outputs, and then doing a lookup....that's only sometimes useful. [1] https://en.wikipedia.org/wiki/Injective_function https://en.wikipedia.org/wiki/Injective_function
- paulddraper 3y agoIf we are talking Excel 365 after Feb 2022, then yes. If we're talking Excel 2021, Excel 2019, etc. then no.
- blowski 3y agoSo Excel supports reusable Lambdas then? In the same way that many tools introduce new features and users need to upgrade versions to get them.
- paulddraper 3y agoYep, Excel 365 Version 2201+ support reusable lambdas.