Returns the specified rows from an array.
تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.
CHOOSEROWS(array, row_num1, [row_num2], ...)The CHOOSEROWS function extracts specific rows from a given array or range based on the row numbers provided. It is a dynamic array function that returns a new array containing only the selected rows in the order specified.
=CHOOSEROWS(A1:C3, 1, 3)النتيجة: Returns the first and third rows of the range A1:C3.
This extracts the first and third rows from the specified 3-row range.
Yes, negative numbers count from the end of the array (e.g., -1 is the last row).