contain in filter

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,
My filter sometimes don't show all kind of records (in
spite select in filter whole shedule). I only can make a
choice a part of records.
Where are rest of records?
How can I do suitably autofilter?
It will appreciate if anyone can help.
Regards
Mark
 
An AutoFilter dropdown list will only show 1000 entries. If your column
has more than 1000 unique items, they can be filtered, but they can't
all be displayed in the dropdown list.

To AutoFilter for an item that doesn't appear in the dropdown list, you
can choose Custom from the drop-down list, and type the criteria. Also,
there are a couple of workarounds here:

http://www.contextures.com/xlautofilter02.html
 
I noticed, filter allow for show 1000 records :)
You found interest solution of this problem.
Thanks for your help
Best regards!
Mark
 
Back
Top