Excel New Function
Excel TAKE function returns a subset of a given array.
Syntax =TAKE(array, Number of rows to return as an integer , Number of Column to return as an integer)
NOTE :- When positive numbers are provided for rows or columns, TAKE returns values from the start or top of the array. Negative numbers take values from the end or bottom of the array.
=TAKE(array,1) // get first rows
=TAKE(array,,3) // get first 3 columns
=TAKE(array,3,2) // get first 3 rows and 2 columns=TAKE(array,-1) // last row
=TAKE(array,,-1) // last column
If rows or columns is zero, TAKE returns a #VALUE error.
#exceltutorial #exceltips #how to excel#shortsvideo
