Re: [libreoffice-users] Copying formulas containg =FILTER

If I'm understanding the question correctly, and without taking the time to test it, it seems to me 
that you need to use absolute addressing for columns A and B.  In other words, make your formula 
=FILTER($B2:$B29, $A2:$A29=D1) and I think that will eliminate the error.


On Fri, Jan 31, 2025, at 9:11 AM, David Lynch wrote:
> See spreadsheet below in csv format.
>
> This spreadsheet shows in columns D to N, rows 2 to 16, the matches in
> column B for each distinct value in column A.
>
> This is by entering the formula =FILTER(B2:B29,A2:A29=D1) as an array
> formula in D2, and =FILTER(B2:B29,A2:A29=E1) into E2 etc
> I have done this by pasting the string "FILTER(B2:B29,A2:A29=D1)" into the
> cells E2,F2, ... N2 in turn and editing the result for each cell separately.
>
> My attempts to copy the formula directly result in Err:533 Nested arrays
> are not supported.
>
> Please, is there a way of copying the formula in cell D2 to cells E2,F2,
> ... N2 more efficiently?
>
> ,,,p,qq,r,ss,t,uuu,v,ww,x,y,zz
> x,10,,47,59,53,12,81,49,64,36,10,21,77
> ss,12,,67,71,,20,,,,,,,
> ss,20,,,79,,24,,,,,,,
> y,21,,,,,30,,,,,,,
> ss,24,,,,,32,,,,,,,
> ss,30,,,,,40,,,,,,,
> ss,32,,,,,48,,,,,,,
> ww,36,,,,,50,,,,,,,
> ss,40,,,,,52,,,,,,,
> p,47,,,,,60,,,,,,,
> ss,48,,,,,68,,,,,,,
> uuu,49,,,,,76,,,,,,,
> ss,50,,,,,80,,,,,,,
> ss,52,,,,,92,,,,,,,
> r,53,,,,,96,,,,,,,
> qq,59,,,,,,,,,,,,
> ss,60,,,,,,,,,,,,
> v,64,,,,,,,,,,,,
> p,67,,,,,,,,,,,,
> ss,68,,,,,,,,,,,,
> qq,71,,,,,,,,,,,,
> ss,76,,,,,,,,,,,,
> zz,77,,,,,,,,,,,,
> qq,79,,,,,,,,,,,,
> ss,80,,,,,,,,,,,,
> t,81,,,,,,,,,,,,
> ss,92,,,,,,,,,,,,
> ss,96,,,,,,,,,,,,
>
>
> David Lynch
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org 
> <mailto:users%2Bunsubscribe@global.libreoffice.org>
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy