Incorrect results on AutoFilter

E

Erica

I have a 5,000 row spreadsheet with a three level sort and three level
subtotal. I added an if-then statement (=IF(K2>10000, "YES", "NO") to check
the results of the one of the columns. I then tried to use AutoFilter to
display only those rows where the result was 'YES'. I am not getting even
close to correct results. I get some rows that say yes and some no. Can
someone help?

Thank you!
 
S

Shane Devenshire

Hi,

What's in column K? If this column contains a formula which can change then
it may be recalculating as the filter is applied. To stop that choose Tools,
Options, Calculation and turn on Manual.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFilter results plus show next row 2
Autofilter is Harmful to your Data 3
Autofilter based on user inputbox 3
Autofilter & copy results 1
manipulating results of autofilter in vba 6
Autofilter & copy results programmatically 1
autofilter question 3
autofilter results based on cell input 5

Top