Filter ignores values!

  • Thread starter Thread starter Amazon
  • Start date Start date
A

Amazon

I didn't know it was possible, but I have encountered several instances
where the filter selection overlooks items in its column. Presently I'm
working in a sorted workbook But when the filter feature is activated and
I'm looking just for a specific item in Col. C, for example, it only shows
three of five possible data selections.

One overlooked item is named 8.00.TUB
too many periods, or is there a TUB function that Excel is mistaking it for?

Advice please. TIA
Jane
 
What criteria are you using in the filter?
What three items are passing through the filter, and what two items are
being filtered out?
 
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

Macro to copy value in field and insert it into filter 2
Filter - not = 3
Advanced Filter how to include columns 1
Filter 1
No filter rows 10
Extract data from table to make a list of cell values 3
Macro to be used with Combo box 1
Req: How to create multiple mutually exclusive filters 2

Back
Top