Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Nov 07, 2024

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

Resources