Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question
    
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) –  Jacob Jan Tuinstra Jan 10 '13 at 20:01
1  
correct @jacob –  user29253 Jan 10 '13 at 20:59
    
What is correct about my statement? –  Jacob Jan Tuinstra Jan 10 '13 at 21:09
add comment

1 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.

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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