Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter Range
Sir,
After specifying some range in a worksheet, only 1000 similar records appear in the autofilter, How I can see more than 1000 records in a filter. Regards, Subhashis Bhowmick Nagpur |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter Range
Hi
The records will be visible within the spreadsheet itself, but you are limited to 1000 unique records displayed in the Autofilter dropdown (at least in xl2003 and below). There is no way around this limit in xl2003 and below of which i am aware. Richard On 19 Jun, 11:16, Subhashis Bhowmick wrote: Sir, After specifying some range in a worksheet, only 1000 similar records appear in the autofilter, How I can see more than 1000 records in a filter. Regards, Subhashis Bhowmick Nagpur |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter Range
You can get round the limitation in a variety of ways. For example,
using a Custom filter and if your values are numeric you can choose Greater than some number, or if the values are text then you could choose Begins with and then enter letters. Hope this helps. Pete On Jun 19, 11:16 am, Subhashis Bhowmick wrote: Sir, After specifying some range in a worksheet, only 1000 similar records appear in the autofilter, How I can see more than 1000 records in a filter. Regards, Subhashis Bhowmick Nagpur |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter Range
Best bet is to use a helper column to get to the appropriate part of the
list. For example, use LEFT(A1) to get the initial letter, filter first by that initial letter, then you can pick up the detail you need & filter by that. -- David Biddulph "Subhashis Bhowmick" wrote in message ... Sir, After specifying some range in a worksheet, only 1000 similar records appear in the autofilter, How I can see more than 1000 records in a filter. Regards, Subhashis Bhowmick Nagpur |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restricted Range in Auto filter | Excel Discussion (Misc queries) | |||
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) |