XLOOKUP: Row by row, find anything you need in a table or range with XLOOKUP.
Dünaamilised massiivid: You can now write one formula in Excel and return an array of values. Use Excel to expedite calculations and insights with 6 new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
Funktsioon LET: Microsoft has included the LET function in Office 2021. It assigns names to calculation results to store intermediate calculations, values, or defining names inside a formula.
Funktsioon XMATCH: The XMATCH function in Excel searches for a specified item in an array/range of cells and returns the item's relative position. XMATCH can also help you return a value in an array.