Hello!
I am running into a #CALC! error when using the filter function. My parameters are reading into formulas on another sheet. I find that when I copy/paste values and covert the text to number, the Filter formula works fine. Is there a way to get around this error while keeping the formula in the parameter cells? Example attached with the first row being 'fixed' through the copy/paste values solution.
Bookmarks