-1

I am using the 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?

4
  • 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) Jan 10 '13 at 20:01
  • 1
    correct @jacob
    – user29253
    Jan 10 '13 at 20:59
  • What is correct about my statement? Jan 10 '13 at 21:09
  • What do you mean regarding "the formula works fine the first time"? Are you filling down several cells with the same formula?
    – Rubén
    Dec 28 '15 at 17:18
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.

3
  • Thanks, but all filter reference is unique. @jacob
    – user29253
    Jan 10 '13 at 21:08
  • I replied correct to your comment that I get in the row below of correct formula I get the statement =CONTINUE(C2,2,1) @jacab
    – user29253
    Jan 10 '13 at 21:47
  • The CONTINUE() function was removed from Google Sheets.
    – Rubén
    Dec 28 '15 at 17:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.