arraysexcelexcel-formula
EXCEL: Array in a cell. How to get the array back?
Let's say I have in B2 the formula =ROW(A1:A3). This formula gives an array of {1;2;3}. Because a cell only holds one value, cell B2 displays a value of 1. Any place in the worksheet, the formula =B2 gives 1, not the array. Yet, Excel still remembers the array because the formula is still in B2.
Is there any way to get the array back so it, the whole array, not its individual elements, can be used for further manipulation? I'm looking for something like OPERATION(B2) = {1;2;3}. For example, SUMPRODUCT(OPERATION(B2)) = SUMPRODUCT(ROW(A1:A3)) = 6.
Solution
As a workaround, you can store your formula in Name Manager, e.g.:
Then you can use it as a reference in Excel formulas, like =INDEX(Rows,2,1):
- Select Token C# Json array
- Getting nested JSON element returns an "Accessed JArray values with invalid key value" error
- slice a list up to a given element
- Can placement new for arrays be used in a portable way?
- How to convert a 3d numpy array to 2d
- Missing $ on loop variable
- returning two arrays in one array that contain names with a certain letter and names without the stated letter
- Pytorch: Test each row of the first 2D tensor also exist in the second tensor?
- Jolt concatenate array into a single JSON object
- Temporarily replace values in string
- The function collects the array and returns it. After ciout memory is still occupied by this array, right?
- C program for multiplying rectangular matrices using arrays prints no result matrix
- Create two arrays for two fields, keeping sort order of arrays in sync (without subquery)
- How to concatenate an empty array with Numpy.concatenate?
- Loop through array with arrays using Javascript
- Recursive Bubble Sort in Java
- JavaScript loop/array
- Looping through the array inside another array
- Apply function to every element of a multidimensional array
- Fastest way to handle undefined array key
- JS array concatenation for results of recursive flattening
- This code changing the image as expected but not the id?
- Array - DS HackerRank in C
- Weird behaviour when passing array to method in C
- How can I output data from a nested array in JavaScript?
- Map two separate array objects into one
- Boolean inside ObservableObject Array does not trigger re-render
- How to retrieve a fixed length string from json array
- Can I define an array type of different type values?
- How to properly type an Array.map callback in TypeScript?