Filter function

Question

I am using filter formula below. The formula works fine the first time, but once it filters the result properly, it corrupts the same formula in next row below with --.

=iferror(FILTER(PROVEEDORES!C:C,PROVEEDORES!B:B=C252),"--- No Existe ---")

How can I fix it?

Answer 1

What happens is you delete the --? When you look what's in the cell, you'll find out it says something like this: =CONTINUE(C2, 2, 1).

This is a clear indication that the current result has lesser values than the previous result.