![]() ![]() Sheet views – This lets you create custom views in a worksheet.XMATCH function - Find an item’s relative position in an array or range of cells.Adds six new functions-FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY. Dynamic arrays - Write one formula to get a variety of values.LET function - Assigns names to calculation results.It can return a value from the left or the right when there is a match, as opposed to VLOOKUP, which can only return values from the right. This is in contrast to VLOOKUP, which only searches vertically. XLOOKUP function - Search for data in a table or range by row or column. ![]()
0 Comments
Leave a Reply. |