Hi,
I'm trying to use FILTER function along with INDIRECT. Where H4 is the name of the column and H3 is value I want to filter by. The equation works on other tables but not on the one I have attached. I have tried different array functions on the problem table that work fine but no filter for some reason. Please see attached. TY!
Bookmarks