Hi,
I created a FILTER formula that works fine, but only up to 147 rows:
=FILTER([SprayAsistFrm.xlsx]SprayAsistFrm!$D$2:$D$147,(
([SprayAsistFrm.xlsx]SprayAsistFrm!$G$2:$G$147=B2)*
([SprayAsistFrm.xlsx]SprayAsistFrm!$F$2:$F$147=F2)))
If I change the "147" to "148" I get the #VALUE error.
It happens also if I change the value in just one of the parameters (as senseless that it is).
Also tried using Name-Ranges and got the same issue.
Any help will be appreciated.
Regards,
Ayal Telem.
Hi Ayal,
It's difficult to troubleshoot without the file, but to be clear, if you change the formula to this:
=FILTER([SprayAsistFrm.xlsx]SprayAsistFrm!$D$2:$D$148,(
([SprayAsistFrm.xlsx]SprayAsistFrm!$G$2:$G$148=B2)*
([SprayAsistFrm.xlsx]SprayAsistFrm!$F$2:$F$148=F2)))
You get an error? If so, there's probably something in row 148 that is causing the error.
I hope that points you in the right direction. If you're still stuck, please share the file.
Mynda
If I remember correctly there is a limit around the 10000 rows to display it in the dropdown list
Thta has nothing to do with your question but just information
Soooo, it turns out that Mynda is right: I had a problem in that row.
Thank you Hans for the information. I didn't think it was a limitation since those are usually in the Power of 2.
Thanks.
