This causes he headaches every time I use ArrayFormulas in Sheets. It seems that you have to specify the exact length of the range, and can't just use for example X2:X like you can in any other range definition in a normal formula. Is there an easy solution for this?
My current formula is:
I would think I could just do:
but it doesn't work. How can this result be achieved?