Forum Discussion
ajl_ahmed
Nov 07, 2024Iron Contributor
Filter Function based on checking group of raws
Hi
I have 1000 raws. I want to use the filter function to check if there is data in each raw to return the corresponding value. It is not worthy to write the filter function like this:
filter(A2:L2,(A3:L3)+(A4:L4)+(A5:L5)+(A6:L6)+(A7:L7)+(A8:L8)+(A9:L9)+(A10:L10)+........)
Is there better way to prepare a function for this purpose?I want to use this function in google sheet
see the attached file
Thanks
Adjust the ranges as needed.
=FILTER(A1:J1, BYCOL(A2:J1000, LAMBDA(col, COUNTA(col))))
Adjust the ranges as needed.
=FILTER(A1:J1, BYCOL(A2:J1000, LAMBDA(col, COUNTA(col))))
- ajl_ahmedIron Contributor
Many thanks