Yes/NO Filter Problem

[silvertabb]

Hi

I have over 2000 cells with data in a column (e.g. Column A). Next to this column (e.g. Column B) I have a criteria that return either YES or NO for each cell. I want to see all NO's but it looks like there are some YES's towards the bottom that also show up. Is there a limit beyond which filter does not work?

 

[doublej_jj]

Just a shot in the dark: Is there a break in your data or is it continuous? The filter will only apply from the heading to first empty row. Maybe?

Jeff

 

[silvertabb]

I am actually looking up a larger list within a shorter list.