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...
- Nov 07, 2024
Adjust the ranges as needed.
=FILTER(A1:J1, BYCOL(A2:J1000, LAMBDA(col, COUNTA(col))))
HansVogelaar
Nov 07, 2024MVP
Adjust the ranges as needed.
=FILTER(A1:J1, BYCOL(A2:J1000, LAMBDA(col, COUNTA(col))))
ajl_ahmed
Nov 07, 2024Iron Contributor
Many thanks