Calculating simple returns (one cell divided by cell above it in same column, result in another column) across large sets of data, google sheets
I'm trying to find a way to automate a simple return calculation (one cell divided by cell above it) across a large set of data which updates/adds cells regularly without having to pull-down the formula. I can't use arrayfunction as it gives me a circular error (all data is in same column). Perhaps there is a way to "split" the column into 2 virtual arrays and then just divide those? Or, another easier way?
Appreciate any and all help!
Solution
Another solution:
=ARRAYFORMULA(ARRAY_CONSTRAIN(A2:A/A1:A-1,COUNTA(A2:A),1))
- Search for a qualifying subarray in a 3d array
- Adding values to a C# array
- Search a 2d array by one column value and return another value from the qualifying row
- Search a multidimensional array by one column value and return another value from the qualifying row
- Get element value from a 2d array row which qualifies because of another column value
- Can I use array_search() to find a whole-row match in a 2d array?
- How to Mark Repeated Entries as True Starting from the Second Occurrence Using NumPy?
- Why arrays are still there when we are actually always using List<T>?
- php - find if an array contains an element
- Doctrine entity object to array
- Determine if an associative array of strings or arrays is equal to another array with the same structure
- Printing array contents in the same line in awk
- Merge two 2d arrays, group by one column and sum another column within each group
- PHP json_decode multiple arrays or array in array to database
- Return the first level key when a column value is found in a 2d array
- Find key of parent in array / PHP
- Find parent key of match in a multidimensional array
- Recursively search a multidimensional array for the parent key of a matched key or value
- Find a parent key in a 2d array
- Get first level key in a 2d array of the first row with a specified value in any element
- Filter a 2d array to only keep rows with a specified value in a specified column
- Access an accompanying value in the first qualifying row of a 2d array
- Get the first level key of a 2d array row with a qualifying value in a specified column
- Get the first level key of the first row containing a specified column value in a 2d array
- Remap values of a flat array based on row data in a 2d array
- Recursively search a multidimensional array for a row with a qualifying column value
- Return values of qualifying row when searching a 2d array
- Get all first level keys from a 2d array where a specified value is found anywhere in the row
- Get the first qualifying whole row from a 2d array
- Recursively search a hierarchical multidimensional array for partial value matches in a column and return values in another column found on the way