J-Des000Brass ContributorJul 17, 2024SolvedFilter 2D Array if row next to it is blank Hi again, I need to filter a column 2D array based on if there are values or not in the row next to it. Sample file attached. Thanks in advance. Show MoreExample.xlsx9 KBHansVogelaarJul 17, 2024J-Des000 If you have Microsoft 365: =FILTER(B9:B13, BYROW(C9:F13, LAMBDA(r, COUNTA(r)<>0)), "")
HansVogelaarJul 17, 2024J-Des000 If you have Microsoft 365: =FILTER(B9:B13, BYROW(C9:F13, LAMBDA(r, COUNTA(r)<>0)), "")
HansVogelaarJul 17, 2024J-Des000 If you have Microsoft 365: =FILTER(B9:B13, BYROW(C9:F13, LAMBDA(r, COUNTA(r)<>0)), "")
HansVogelaarMVPJul 17, 2024J-Des000 If you have Microsoft 365: =FILTER(B9:B13, BYROW(C9:F13, LAMBDA(r, COUNTA(r)<>0)), "")
