Forum Discussion
Laosi
May 25, 2025Copper Contributor
BROKEN FILTER FORMULA AFTER UPDATE QUERY
Can someone please help, my filter formulas seems got broken after i update my query. I make table in several sheets cointaining filter function, the purpose is to find the MAX and MIN of data perce...
Patrick2788
May 29, 2025Silver Contributor
You can resolve the #CALC! by providing a value in FILTER's if_empty argument: