Incorrect results on AutoFilter

  • Thread starter Thread starter Erica
  • Start date Start date
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!
 
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.
 
Back
Top