3 ms·
User defined functions have been available as long as I can remember in Excel! Yes they must be defined in VBA and the VBA Editor feels like it has not been upd
by garyclarke27 6y ago
User defined functions have been available as long as I can remember in Excel! Yes they must be defined in VBA and the VBA Editor feels like it has not been updated since 1980, but they are still quite easy to write and extremely powerful and useful.
These lambdas look great and a bit more accessible than opening VBA, but I don’t get why they are being hailed as some kind of revolutionary paradigm shift for Excel.
- perl4ever 6y agoYou can write anything in VBA, (the horror...the horror) and Power Query also seems to be a complete more or less functional programming language. So I believe Excel was Turing complete for almost 30 years and doubly so for a significant part of the last decade. There might be more languages lurking in there somewhere.