=SELECTROWS(A1:Z100, "Salary > 100000, Department = IT") -> A1:Z10
DEFINE(
SELECTROWS,
LAMBDA(
table_range,
[row_conditions],
IFOMITTED(
row_conditions,
table_range,
LET(
column_names,
FIRSTROW(table_range),
VSTACK(
column_names,
SIEVE(
HEADLESS(table_range),
CRITERIATABLE(
column_names,
row_conditions)))))))
Help us optimize this function