UNIQUE() =UNIQUE(A2:A100) : Distinct list

FILTER() =FILTER(A2:D100,B2:B100="East") : Filter rows by condition

SORT() =SORT(A2:B100,2,-1) : Sort range

SORTBY() =SORTBY(A2:B100,B2:B100,-1) : Sort by column, keep all data

SEQUENCE() =SEQUENCE(10,1,1,1) : Generate sequence numbers

RANDARRAY() =RANDARRAY(5,3,1,100,TRUE) : Random array

XLOOKUP() =XLOOKUP(E2,A2:A10,B2:B10,"NF") : Modern lookup spills

XMATCH() =XMATCH(E2,A2:A10) : Array enabled match

CHOOSECOLS() =CHOOSECOLS(A2:F10,1,4) : Return selected columns

CHOOSEROWS() =CHOOSEROWS(A2:F10,1,-1) : Return selected rows

TAKE() =TAKE(A2:F100,5) : First N rows/cols

DROP() =DROP(A2:F100,-3) : Drop last rows/cols

WRAPROWS() =WRAPROWS(B2:B13,3) : Wrap list into rows

WRAPCOLS() =WRAPCOLS(B2:B13,3) : Wrap list into columns

LET() =LET(rng,A2:A10,AVG,AVERAGE(rng),AVG) : Use variables for clarity

LAMBDA() =LAMBDA(x,y,x+y)(2,3) : Create reusable custom function