MY SPREADSHEET IS NOT FILTERING CORRECTLY

L

leighanne

I am trying so filter a selected persons data, to get a correct cost for this
person but at the bottom of the page it is also bringing up different people
which I do not want can anyone help
 
D

Dave Peterson

It sounds to me like your autofilter range isn't set right.

Next time you see this behavior, look at the row numbers. The rows that are in
the visible filtered range will have blue row numbers.

If the row numbers that you see (that don't belong) are not blue, just remove
the filter and select your complete range and reapply data|filter|autofilter.
 
Top