TAKE

The TAKE function returns a specific number of rows and columns from an array.

TAKE(array, number-of-rows, number-of-columns)

array: The array from which to take rows or columns.

number-of-rows: The number of rows to take.

number-of-columns: The number of columns to take.

Notes

  • A negative value for number-of-rows or number-of-columns takes from the end of the array.

  • You can use the spilled range operator “#” to reference an array created by a formula.

Examples

=TAKE(A1:C10, 5, 2) returns the first 5 rows and first 2 columns.

=TAKE(A1:C10, -3, -2) returns the last three rows and last 2 columns.

=TAKE(A1:C10,,-2) returns the last two columns.

See alsoDROPFILTERUNIQUE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
મદદરૂપ થયું?
અક્ષરની સીમા 250
મહત્તમ અક્ષરની સીમા 250 છે.
તમારા પ્રતિસાદ બદલ ખૂબ ખૂબ આભાર.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.