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