4 ms·

XLOOKUP, XMATCH, dynamic arrays and related functions. There are also new regex functions, but it seems that those didn’t make the cut for Excel 2024, unfortuna

by layer8 2y ago

XLOOKUP, XMATCH, dynamic arrays and related functions. There are also new regex functions, but it seems that those didn’t make the cut for Excel 2024, unfortunately. I had situations in the past where lambdas would have been handy.