MATCH
Searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
TRANSPOSE
Returns a vertical range of cells as a horizontal range, or vice versa.
ROW
Verilen bir başvurunun satır numarasını döndürür; sıralama, dizi formülleri ve dinamik adresleme için temeldir.
XLOOKUP
Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest match.
HLOOKUP
Looks for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify.
OFFSET
Returns a reference to a range that is a specific number of rows and columns from a cell or range of cells.
VLOOKUP
Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify.
PIVOTBY
Satır ve Sütunlara göre işlem yapan yeni nesil bir Excel fonksiyonudur.
DROP
Excludes a specified number of rows or columns from the start or end of an array.
TAKE
Returns a specified number of contiguous rows or columns from the start or end of an array.
WRAPCOLS
Wraps the provided row or column of values by columns after a specified number of elements.
WRAPROWS
Wraps the provided row or column of values by rows after a specified number of elements.