Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to expand the autofilter range 1000 to 10000?
How can I expand the excell autofilter range 1000 to 10,000? Also how could I
create a search engine for my excell data base in order to search and fine what I am looking for in a thousands of datas? If you could sent answer to my email please! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to expand the autofilter range 1000 to 10000?
"master777" wrote:
How can I expand the excell autofilter range 1000 to 10,000? Also how could I create a search engine for my excell data base in order to search and fine what I am looking for in a thousands of datas? Don't think that is possible, but you could try Debra Dalgleish's page at: http://www.contextures.com/xlautofilter02.html#Limits Limits to Dropdown Lists (workarounds) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to expand the autofilter range 1000 to 10000?
It is important to realise that the filter range can apply to the whole
column (65,000+ values), but that only 1000 different values are visible in the pull-down list. However, the filter is still active for all of the values. Try filling a sequence of numbers in column A - 1, 2, 3, 4 etc and applying the autofilter. You will only see the numbers up to 1000 in the pull-down, but if you select Custom | Greater than | 2000 you will see those higher values filtered. Hope this helps. Pete Max wrote: "master777" wrote: How can I expand the excell autofilter range 1000 to 10,000? Also how could I create a search engine for my excell data base in order to search and fine what I am looking for in a thousands of datas? Don't think that is possible, but you could try Debra Dalgleish's page at: http://www.contextures.com/xlautofilter02.html#Limits Limits to Dropdown Lists (workarounds) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to expand the autofilter range 1000 to 10000?
Good clarification, Pete. Thanks.
My "kneejerk" presumption upon reading the words: autofilter, 1000 might have been wrong -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limiting the range of AutoFilter? | Excel Worksheet Functions | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
What is Range For Chart AutoFilter Range VBA? | Excel Discussion (Misc queries) | |||
Define a range based on another named range | Excel Worksheet Functions |