Timeline for ARRAYFORMULA in Google Sheets with nested array functions
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 18, 2023 at 12:14 | answer | added | David Knapp | timeline score: 0 | |
| Feb 25, 2016 at 12:07 | comment | added | Max Makhrov | I found similiar questions here and here. Will it help you? | |
| Feb 24, 2016 at 9:14 | history | edited | Simon Fischer | CC BY-SA 3.0 | Tried to clarify issue. |
| Feb 24, 2016 at 8:48 | comment | added | daniel | Please provide more clarification on what you want. Do you want the function to return one single value or an array? Your question is confusing because max and min both return single value, but you are asking about arrayformula ? Are you asking about optimization of your function, in which case you should really provide actual code? | |
| Feb 24, 2016 at 8:03 | history | edited | Simon Fischer | CC BY-SA 3.0 | Tried to make it even clearer that workarounds are not what I am asking for. |
| Feb 24, 2016 at 7:10 | answer | added | daniel | timeline score: 0 | |
| Feb 24, 2016 at 6:43 | comment | added | Simon Fischer | Input={10, 5, 0, -5, -10} -> Output={2, 1, 0, 0, 0} | |
| Feb 24, 2016 at 0:47 | comment | added | daniel | Please provide example that look like this: input = {1, 2, -3, 5, 10, 0, -1}, output = {1,2,5,10}. It looks like the function you want is filter() | |
| Feb 23, 2016 at 22:11 | answer | added | JPV | timeline score: 1 | |
| Feb 23, 2016 at 19:19 | history | edited | Simon Fischer | CC BY-SA 3.0 | Clarified lower-bound |
| Feb 23, 2016 at 19:18 | comment | added | Simon Fischer | By lower bound I mean the result should be at least 0. Hence the max. The division by 5 is just an example to provide something meaningful to arrayformula. Input=10 -> Output=2. Input=-10 -> Output = 0. | |
| Feb 23, 2016 at 18:37 | comment | added | daniel | What do you mean by "lower bound"? Please provide an example of a list of input values and a list of desired output. | |
| Feb 23, 2016 at 17:42 | history | asked | Simon Fischer | CC BY-SA 3.0 |