Restricted Range in Auto filter

[Guest]

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

 

[RichardSchollar]

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

 

[Peo Sjoblom]

If you need to filter 65536 rows you are using the wrong program, Access
would be much better.