Forum Discussion
Dynamically filter table on basis of range of criteria
Hi, I have a large table (150k rows) loaded to Excel from power query and I want to filter the description column (column N) dynamically on a couple of key words. It should be an AND filter so the...
=FILTER(CHOOSECOLS(Database,13,14,34),BYROW(Database[Description],
LAMBDA(x,SUM(N(ISNUMBER(SEARCH(Criteria[Criteria],x))))=3)))
This formula works in my Excel online sample sheet. I've named the large table Database and the small table Criteria.
Thx, in the mean time I came to a similar filter solution however static (declaring criteria 1,2 etc) but yours is dynamic and just a bit better. Many thanks and regards,