Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricted Range in Auto filter
Sir,
I have filtered some range in a sheet in Excel 2000, with a title. But it take only 1000 records / rows in its filter range while searching, such as if I had entered some 1500 different values it will show me the first 1000 value in its range in assending order, and out of which if few records repete values in range it includes in it. Can you tell me any way so that it can take all the data of different range within range 1st row to 65536th row. Thanks & Regards, Subhashis Bhowmick NAGPUR |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricted Range in Auto filter
Hi
The autofilter results displayed in the autofilter dropdown are limited to 1000 unique records - the entire filter range will be filtered if you apply a filter in the dropdown, however, not just the first 1000 records. If you want to return unique results then you should look at using Advanced Filter instead. Best regards Richard On 19 Jun, 11:11, Subhashis Bhowmick <Subhashis wrote: Sir, I have filtered some range in a sheet in Excel 2000, with a title. But it take only 1000 records / rows in its filter range while searching, such as if I had entered some 1500 different values it will show me the first 1000 value in its range in assending order, and out of which if few records repete values in range it includes in it. Can you tell me any way so that it can take all the data of different range within range 1st row to 65536th row. Thanks & Regards, Subhashis Bhowmick NAGPUR |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricted Range in Auto filter
If you need to filter 65536 rows you are using the wrong program, Access
would be much better. -- Regards, Peo Sjoblom "Subhashis Bhowmick" <Subhashis wrote in message ... Sir, I have filtered some range in a sheet in Excel 2000, with a title. But it take only 1000 records / rows in its filter range while searching, such as if I had entered some 1500 different values it will show me the first 1000 value in its range in assending order, and out of which if few records repete values in range it includes in it. Can you tell me any way so that it can take all the data of different range within range 1st row to 65536th row. Thanks & Regards, Subhashis Bhowmick NAGPUR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
Separate Button for Auto Filter Selected Range | New Users to Excel | |||
Range limit for auto filter function | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |