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: [email protected] > <mailto:users%[email protected]> > 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: [email protected] 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
