MY SPREADSHEET IS NOT FILTERING CORRECTLY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

Filtering 2
Filter question 4
New rows not added to data filtering 3
My filter does not pick up all text 5
Using Filter more than once 2
Results of filters 3
subtotal not showing after filtering list 1
Filter not including added data 5

Back
Top