Is it possible to chain array formulae?
i.e.)
Assume a column of values such as "Max", "Michael", "Kyle", "Michael"
starting in A1
Then a formula such as =UNIQUE(A1:A4)
in A2
("Max", "Michael", "Kyle"
)
Is there a way to put a second formula in A3
such as =LEN(A2)
that will return an array {3, 7, 4}
and spill to the below rows?
I want to create effectively an automatically-updating table that expands based on the output of UNIQUE
, that keeps certain intermediate results between the initial array and the final column of calculated values.
I do not want to have to use something like MAP(UNIQUE(A1:A4), LAMBDA(x, LEN(x)))
as many intermediate steps use long, complex formulae and the resulting lambdas and inputs would rapidly become very cumbersome and difficult to edit.