[libreoffice-users] Copying formulas containg =FILTER

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
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