Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Nov 07, 2024
Solved

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...
  • HansVogelaar's avatar
    Nov 07, 2024

    Adjust the ranges as needed.

    =FILTER(A1:J1, BYCOL(A2:J1000, LAMBDA(col, COUNTA(col))))