Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 18 Jul 2013 05:35:26 +0200How do I make an array formula out of a function that normally takes array arguments?https://ask.libreoffice.org/en/question/20404/how-do-i-make-an-array-formula-out-of-a-function-that-normally-takes-array-arguments/What I've managed to do successfully:
{=SIN(A1:A3)}
This formula will iterate the sine function over rows 1 through 3, returning {SIN(A1);SIN(A2);SIN(A3)}. I can then pass the array to the AVERAGE function:
{=AVERAGE(SIN(A1:A3))}
This returns a single number, the average of the three sines.
However, I am unable to get the same behavior out of an inner function that normally takes an array. For example, if I wanted to find the max number from columns A through C over three rows, I might write something like this:
{=MAX((A1:A3):(C1:C3)))}
However, this statement will search the 3x3 matrix for the single largest number and return it, i.e. {MAX(A1:C3)}. Is there any way to get each row to evaluate individually, to get {MAX(A1:C1);MAX(A2:C2);MAX(A3:C3)}?
And yes, I know that I could just use a column of intermediate cells to hold the MAX values and then AVERAGE them, but I'd rather not clutter up the spreadsheet.FragileXThu, 18 Jul 2013 05:35:26 +0200https://ask.libreoffice.org/en/question/20404/